Page 1 of 1

data with leading zero... (in MySQL)

Posted: Tue Feb 03, 2004 10:05 am
by apek
what is the data type that allow leading zero???
i try to fill 01,02...but it keeps storing 1,2....

Posted: Tue Feb 03, 2004 10:16 am
by mikusan
Try using strings. And then reformat it, or cast it to whatever.

Posted: Tue Feb 03, 2004 10:17 am
by apek
theres no STRINGS data type in mysql....

Posted: Tue Feb 03, 2004 10:28 am
by qads
VARCHAR should do the job.

Posted: Tue Feb 03, 2004 1:53 pm
by mikusan
Doh :)
I didn't catch the this is a mysql question hint...

Posted: Wed Feb 04, 2004 4:59 am
by twigletmac
I've moved this to Databases. Please take the time to clearly identify what you are asking, post in the relevant forum and also don't post the same problem in a multitude of different places. It'll only get confusing for you and irritating for other users.

Mac