From: Baron Schwartz
Date: September 30 2007 3:03pm
Subject: Re: Having trouble storing monetary values...
List-Archive: http://lists.mysql.com/mysql/209322
Message-Id: <46FFBABB.3000706@xaprb.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Rick Faircloth wrote:
> Hi, all.
> 
>  
> 
> I'm having trouble storing monetary values.
> 
>  
> 
> When MySQL 5.0 stores the entered value of 5.23,
> 
> it storing it as 5, dropping off the values after the decimal.
> 
>  
> 
> The field is the decimal type with 2 specified as the number
> 
> of values to store after the decimal.
> 
>  
> 
> Can anyone provide some clues on how to set up the field
> 
> or any other changes I need to make to properly store
> 
> the monetary values?

Please send us the exact column definition from SHOW CREATE TABLE.  You 
should be able to use a definition like DECIMAL(10,2) or similar.

Baron