Re: phpMyAdmin Question

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Sil ent_column_changes ---John Holmes... ----- Original Message ----- From: "Scott Reismanis" <areisman@bigpond.net.au> To: <php-general@lists.php.net> Sent: Monday, May 06, 2002 4:58 AM Subject: [PHP] phpMyAdmin Question > Hey all, > > This question is mainly mySQL related however I believe the problem > maybe caused by phpMyAdmin which is why I am posting it here. Anyhow > does mySQL tables allow for a mix of char / varchar columns? Because if > I try to create a table in phpMyAdmin for example: > > CREATE TABLE generic ( > title char(20) NOT NULL, > title_alternate varchar(40) NOT NULL > ) TYPE=MyISAM; > > it will always be stored as: > > CREATE TABLE generic ( > title varchar(20) NOT NULL, > title_alternate varchar(40) NOT NULL > ) TYPE=MyISAM; > > and I am unable to force it to char. The only reason why this is a > problem is char columns are quicker to process thus it would be ideal to > mix such columns rather than be forced to create another table for > example, > > Thanks for your time, > > Scott Reismanis > > > >