[Webdev] MySQl & Leading zero's

[Dave Burke]

howya!

Is there anyway to stop mysql from chopping out the leading zero's from a
bigint field?

Say I do the following........

INSERT INTO database.table VALUES ('00345', etc.

Mysql removes the leading zero's and stores it as 345.

Is there anyway to prevent it from doing this short of recreating the
field as a text field, which I'd obhiously prefer not to have to do.

Cheers!

Dave