Page 1 of 1

MySQL Integers with '0' at begining

Posted: Fri Jul 04, 2003 6:49 pm
by kendall
Hello,

Whats data type should i use when entering data type that would allow integers with 0 at the begining??

Kendall

Posted: Fri Jul 04, 2003 10:33 pm
by Stoker
an integer as a type does not contain leading zeroes as it is an n+ bit single whole number. Such would be at the presentation level. If for some odd reason you need to store such it must be as a string or binary type (E.g. Character Varying), likely to use more storage space than a fit-size integer...