Use decimal(10,2) for fields that will contain monetary values. If you use a float it will round the values, while decimal won't.
Matthew Walker Ecommerce Project Manager Mountain Top Herbs -----Original Message----- From: Keith W [mailto:[EMAIL PROTECTED]] Sent: Monday, January 07, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: money datatype I'm porting a MS-SQL system to a Solaris machine running Mysql. In the MS-SQL there is a datatype of money what would be the proper datatype in mysql to use as a replacement for this? Keith --------------------------------------------------------------------- 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 1/2/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 1/2/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