Hi all, I have a MyISAM table with a decimal field (12,2) I have loaded a bunch of data into this table, from ascii dumps of data being migrated from other systems. Some of these dumps include a value for the decimal field in the form of "00078000.00"
My understanding was that decimal fields behave like numeric fields, but are stored like char field. So i had assumed that the lead zeros would be dropped, in the spirit of a numeric field, but they are kept, in the spirit of a char like field. The lead zero's screw up the formatting for various display API's (homecooked). I'm not arguing that this behaviour is a bug, i am more interested in knowing why this behaviour is the way that it is. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]