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