Hi Mike Thanks for your reply
Just to check the decimal(6, 2) means show 6 digits to the 2 decimals of percision. Thus you get a numbers like: 1.34 300000.00 3344.92 Is that correct? Why do you not use a float and a decmial type? Thanks Desmond >From: "Mike(mickako)Blezien" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Desmond Lee <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: currency type >Date: Tue, 30 Jul 2002 11:36:30 -0500 > > >>Desmond Lee wrote: > > > > Hi there > > > > Does mysql have a currency type, or is it best to just use a varchar or >a > > float? > > > > Thanks > > > > Desmond > >I normally use the DECIMAL(6,2) data type, works very for currency values. >-- >Mike(mickalo)Blezien >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= >Thunder Rain Internet Publishing >Providing Internet Solutions that work! >http://www.thunder-rain.com >Tel: 1(985)902-8484 >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > >--------------------------------------------------------------------- >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 _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- 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
