best way to store currency amounts in MS SQL

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
I see that they have a money variable, but im curious if it will work with all currencies...

off to google I go!

I need to store money values for everythign from YEN, rupees, to the dollar... everything really, so I need a variable store that will accomodate all...
 

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
Originally posted by: Modeps
How about a float?

well, there will be decimal entries... so that may be the way I go... im still looking around for "best practice" knowledge...
 

WannaFly

Platinum Member
Jan 14, 2003
2,811
1
0
there is a money data type in MSSQL, use it. It properly handles rounding, etc.

edit: i didnt read your whole post. Im not sure if it will work with other currencies. If it doesnt, decimal is probably best.
 

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
Originally posted by: WannaFly
there is a money data type in MSSQL, use it. It properly handles rounding, etc.

edit: i didnt read your whole post. Im not sure if it will work with other currencies. If it doesnt, decimal is probably best.

thanks... i was aware of the money type, but my concern was functionality with other currencies... im probably going with decimal.