ID: 8352 Updated by: rasmus Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MySQL related PHP Version: 4.0.2 Assigned To: Comments: User misunderstood how MySQL's decimal() works. Previous Comments: --------------------------------------------------------------------------- [2000-12-21 09:30:21] [EMAIL PROTECTED] mysql_field_len on a decimal field only report the length before the dot: create table articles ( articleid int(11) primary key auto_increment, price decimal (9,2) ); mysql_field_len on the field decimal returns a 9. I think it should be a 12 (9 before, 2 after and 1 for the point)? --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8352&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]