[AccessD] Re: Number vs text data type

Robert L. Stewart rl_stewart at highstream.net
Tue Oct 14 15:46:32 CDT 2003


Gustav,

Okay, you win.  8-)

I have not used 97 in more than a few years.

I think we will agree to disagree.  I love the
way my Base 36 system works and have converted
a number of the developers that I mentor through
the Special Interest Group I have been a leader
of for about 14 years.  But, then again, I have
only been using it for about 4 years.  So I have
a checkered past of using different things also.
But, I also do not beat them with my shillelagh
to get them to use it.

Robert

P.S.  shillelagh is an Irish weapon like a war club

At 03:26 PM 10/14/2003 -0500, you wrote:
>Date: Tue, 14 Oct 2003 20:07:20 +0200
>From: Gustav Brock <gustav at cactus.dk>
>Subject: Re: [AccessD] Re: Number vs text data type
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <15443507981.20031014200720 at cactus.dk>
>Content-Type: text/plain; charset=us-ascii
>
>Hi Robert
>
>Just a note.
>
> >>The exceptions are only those where the numbers exceed the capacity of
> >>your database engine, normally at least 14 digits (Jet: Currency) and
> >>a Long Integer is always available which holds 9 digits.
>
> > RLS:  By using scientific notation, you can go past this also.
> > Decimal = 10 ^28 -1
>
>That's right but the Decimal datatype was not used by the Jet engine
>before version 4 (Access 2000). For A97 and earlier that means you
>would have to store it in some fancy way using compound fields or,
>say, like a string!
>
>/gustav




More information about the AccessD mailing list