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
