Will the data in this field always be numbers? you could just use TINYINT(2) UNSIGNED ZEROFILL
-----Original Message----- From: Rochester, Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:56 AM To: MySQL (E-mail) (E-mail) Subject: How do you set the char format for a column in Mysql table I have a Mysql table with a char(2) column, name is Dependents. I want the value that I insert to always be to places. I have tried Insert into Table1 Dependents values '02'; but it inserts 2 in the Dependents column How do I make it insert 02? Thanks Dean-O --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
