Hi all, I've tried to create the following type of field in a table:
create table temp(id float(100,50) unsigned); insert into temp values(123.1234567890123456789012345678901234567890123456789012345); select * from temp; This prints: 123.123458862304690000000000000000 What's wrong with MySQL? It didn't give me any error when creating the table or inserting the data, but it modifies the number. Thank you. I use MySQL 4.05 under Windows 2k. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
