Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
apek
Forum Commoner
Posts: 96 Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru
Post
by apek » Tue Feb 03, 2004 10:05 am
what is the data type that allow leading zero???
i try to fill 01,02...but it keeps storing 1,2....
mikusan
Forum Contributor
Posts: 247 Joined: Thu May 01, 2003 1:48 pm
Post
by mikusan » Tue Feb 03, 2004 10:16 am
Try using strings. And then reformat it, or cast it to whatever.
apek
Forum Commoner
Posts: 96 Joined: Tue Jan 06, 2004 11:19 pm
Location: Holiday Plaza Johor Bahru
Post
by apek » Tue Feb 03, 2004 10:17 am
theres no STRINGS data type in mysql....
qads
DevNet Resident
Posts: 1199 Joined: Tue Apr 23, 2002 10:02 am
Location: Brisbane
Post
by qads » Tue Feb 03, 2004 10:28 am
VARCHAR should do the job.
mikusan
Forum Contributor
Posts: 247 Joined: Thu May 01, 2003 1:48 pm
Post
by mikusan » Tue Feb 03, 2004 1:53 pm
Doh
I didn't catch the this is a mysql question hint...
twigletmac
Her Royal Site Adminness
Posts: 5371 Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK
Post
by twigletmac » Wed Feb 04, 2004 4:59 am
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