[RESOLVED] zeros not showing in mysql

[netfrugal]

I need to enter numbers into MySQL.

Like this: 000562, 000236, 000142

But when I enter them into mysql the zeros disappear. How do I stop that and make the zeros show?

thanks!

[netfrugal]

Figured it out!

I changed the column type to CHAR. VARCHAR did not work for some reason.

[Piranha]

1. VARCHAR works, but you have to add it as a string.

2. Why don't you use INT and change it when you get the info?