Page 1 of 1

MySQL int column removing prefixed zero

Posted: Tue Oct 30, 2007 12:20 pm
by impulse()
Do I need to change the columns data type to stop MySQL removing the a zero from the beginning if there is one?

Posted: Tue Oct 30, 2007 12:23 pm
by feyd
You wish to keep the leading zeroes? There is a column setting for it.

Posted: Tue Oct 30, 2007 12:37 pm
by impulse()
A-ha!

The unsigned zerofill.