On Tue, 05 Jun 2001 12:53:50 -0500 (CDT), Don Read <[EMAIL PROTECTED]>   wrote:

We use DECIMAL(X,X) for all our currency related data columns, works perfectly.
Usually DECIMAL(9,2) seems to work the best.

>>
>>On 05-Jun-01 Aaron Clausen wrote:
>>> I've been having some problems with currency calculations in SQL
>>> queries.
>>> I've been using Double, but often get some very small rounding
>>> errors.  What
>>> is the recommended column type for currency in MySQL?
>>> 
>>
>>

Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
















---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to