Re: MS SQL [ when to use the money datatype ]

2004-04-06 Thread Jochem van Dieten
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

Re: MS SQL [ when to use the money datatype ]

2004-04-06 Thread Nick de Voil
> 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

Re: MS SQL [ when to use the money datatype ]

2004-04-06 Thread Jochem van Dieten
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

Re: MS SQL [ when to use the money datatype ]

2004-04-05 Thread Dick Applebaum
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

MS SQL [ when to use the money datatype ]

2004-04-05 Thread Dan Farmer
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