FN-FORUM: Storing the leading 0 of product codes in MySQL

date posted 11th October 2006 10:32

Morning all again,

Right, I am storing products codes, split into two fields, one for
characters, and one for digits.. The problem is that I need 01 stored
as 01 and not as 1, and sadly I can't store it in the characters
field... so is there a field type that preservers the 0?

D