From: sean peters (speterswiredata.com)
Date: Thu Nov 13 2003 - 13:43:10 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
speterswiredata.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]