3 messages in com.mysql.lists.win32MySQL 4.1
FromSent OnAttachments
Sheng, Joseph Y [AMSTA-AQ-AP]16 May 2005 11:50 
SGr...@unimin.com16 May 2005 12:54 
mfat...@free.fr16 May 2005 13:07 
Subject:MySQL 4.1
From:Sheng, Joseph Y [AMSTA-AQ-AP] (jose@us.army.mil)
Date:05/16/2005 11:50:21 AM
List:com.mysql.lists.win32

I have created a table through EMS in my MySQL 4.1. One of the datafield, Amount, is a type of Double for Size=15 and Precision=2. When I issue an Insert statement, the data in the Amount filed is truncated.

For example,

if Amount = '16,000.00', it will be stored as 16.000 in the DB.

if Amount = '1,000,000.00', it will be saved as 1.000 in the DB.

INSERT INTO Reservation(ResvNum, Amount, RespDate) VALUES('W15Q05T0918', '1,000,000.00', '05/20/2005')

Any pointers? TIA.

...Joe