MySQL 4.1 2005-05-16 - By Sheng, Joseph Y [AMSTA-AQ-AP]
Back
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
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=mysql@(protected)
Earn $52 per hosting referral at Lunarpages.
|
|
