Keeping the 0 in database input?

[eluser]AgentPhoenix[/eluser]
There is a "feature" in MySQL where, no matter if it's text or not, it'll truncate leading zeros. I ran in to that problem myself. MySQL recommends using zerofill, but what they don't tell you is that in some versions of MySQL, you can't set that attribute on integer fields. Fantastic, huh?