List:General Discussion« Previous MessageNext Message »
From:Mike(mickako)Blezien Date:July 30 2002 4:36pm
Subject:Re: currency type
View as plain text  
>>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
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thread
• currency typeDesmond Lee30 Jul
  • Re: currency typeMike(mickako)Blezien30 Jul
  • Re: currency typeHarald Fuchs31 Jul
• Re: currency typeDesmond Lee30 Jul
  • Re: currency typePaul DuBois30 Jul