Nick de Voil wrote:
>> You should use numeric or decimal. Both are exact numeric types
>> which allows you to specify the precision. The main reason not to
>> use money is that it is not completely standardized, i.e. there
>> is no money type in the JDBC spec. Also, depending on your
>> requirement
> You should use numeric or decimal. Both are exact numeric types
> which allows you to specify the precision. The main reason not to
> use money is that it is not completely standardized, i.e. there
> is no money type in the JDBC spec. Also, depending on your
> requirements, using numeric and a se
Dan Farmer wrote:
> This may seem obvious but I have some fields that do represent money or
> dollars.
>
> Should I use ( int, varchar or money ) what advantages does 'money' have
> over 'int' ?
You should use numeric or decimal. Both are exact numeric types
which allows you to specify the pre
Money has a several advantages.
It handles dollars and cents
sorting money will give different (correct) results and text will not.
It possibly could be localized by an intelligent db.
It represents what the data type truly is.
Or, you could just store it as a blob :)
HTH
Dick
On Apr 5, 200
This may seem obvious but I have some fields that do represent money or
dollars.
Should I use ( int, varchar or money ) what advantages does 'money' have
over 'int' ?
__
Daniel Farmer
Producer / Coldfusion Developer
http://www.bernardclark.com/danfarmer.ca
P: 613
5 matches
Mail list logo