[Webdev] MySQl & Leading zero's

[adam beecher]

Dave,

See the ZEROFILL attribute in Numeric Types in the MySQL docs:

http://www.mysql.com/Manual_chapter/manual_Reference.html#Numeric_types

You'll still need to ALTER the table definitions though.

HTH,
adam


> -----Original Message-----
> From: webdev-admin at linux.ie [mailto:webdev-admin at linux.ie]On Behalf Of
> Dave Burke
> Sent: 14 June 2000 17:46
> To: webdev at linux.ie
> Subject: [Webdev] MySQl & Leading zero's
> 
> 
> howya!
> 
> Is there anyway to stop mysql from chopping out the leading zero's from a
> bigint field?
> 
> Say I do the following........
> 
> INSERT INTO database.table VALUES ('00345', etc.
> 
> Mysql removes the leading zero's and stores it as 345.
> 
> Is there anyway to prevent it from doing this short of recreating the
> field as a text field, which I'd obhiously prefer not to have to do.
> 
> Cheers!
> 
> Dave
> 
> 
> _______________________________________________
> Webdev mailing list
> Webdev at linux.ie
> http://www.linux.ie/mailman/listinfo/webdev
>