field type '0111'

[mikerh9]

What is the field type for value '0111'?

Integer strip first 0 and varchar works.

Is it possible to present '0111' in integer type.

TH

[dream_scape]

Change the column type to "INT(4) ZEROFILL", and 111 will be retrieved as "0111"; 11 would be retrieved as "0011"; etc...

The other option is to use a non-numeric column type, such as varchar.

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html