Rob Gould <[EMAIL PROTECTED]> writes: > I've got a PHP script that inserts "00012345678" into a record in a > mySQL database (it's a barcode). Things work ok unless the number has > preceding zeros, and then the zeros get cut off and all I get is > "12345678". > > I have the mySQL database fieldtype set to bigint(14). If the maximum > length a barcode can be is 14, is there a better fieldtype to use that > will keep the zeros?
Use ZEROFILL, example: CREATE TABLE `db`.`table` ( `barcode` integer(14) ZEROFILL NOT NULL ) -- Emilio Astarita <[EMAIL PROTECTED]> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
