Edited by author 01-03-2005 09:07 AM
Decimal support has always been a little neglected, and this includes the documentation, but the key phrase is, "MySQL stores DECIMAL and NUMERIC values as strings..."

try: insert into example values ('1.1')

what is happening is mysql is seeing a bare 1.1 and is converting it to a float before insert

btw the reason you get '99.99999' rather then '9.9999' when inserting 1000 is because MySQL uses the signed bit for positive numbers to try to handle overflow