How to keep leading Zero when inserting Int into field
Posted: Mon Oct 20, 2003 9:50 am
I have a field in a MySQL table that i have sent to Int(4)
The numbers are going to be starting at 0001 and going upwards.
But when i insert into the field, the leading Zero's get chopped off. How can i keep them?
Do i need to change the filed type?
Thanks
Mark
The numbers are going to be starting at 0001 and going upwards.
But when i insert into the field, the leading Zero's get chopped off. How can i keep them?
Do i need to change the filed type?
Thanks
Mark