Re: Trunkated zeros..... how to fix?

use zerofill for the column when you create the table! --- "Dallas K." <dallask@austin.rr.com> wrote: > I am having the problem that Mysql is truncating the > zeros from both the int and char fields when I try to > insert.... How can I fix this..... > > example: > > 0123 in PHP = 123 in mysql > 3210 in PHP = 321 in mysql > > but I need that zero.... how do I keep mysql from doing > this? > ===== Mehmet Erisen http://www.erisen.com __________________________________________________ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com