This behavior is okay and is normal. MySQL sees the varchar(20) column [identified by `item`] and because one column is variable, MySQL changes all columns to be variable...
Have a look at the MySQL manual here: http://www.mysql.com/doc/en/Silent_column_changes.html On Tue, 13 Aug 2002, Pushkar Pradhan wrote: > I'm not very familiar with dbs, I'm creating tables in mysql 3.23.49 and > even though I specified a field as CHAR (e.g. customer CHAR(9)) when I do > a show create table on this table it displays that this field is a > VARCHAR(9). > | sales | CREATE TABLE `sales` ( > `item` varchar(20) default NULL, > `employee` varchar(9) default NULL, > `quantity` smallint(5) unsigned zerofill default NULL, > `price` float default NULL, > `customer` varchar(9) default NULL, > `date` date default NULL > ) TYPE=MyISAM | > > Is this okay behaviour? > -Pushkar S. Pradhan > > > --------------------------------------------------------------------- > 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