phpMyAdmin Question
| From: | Scott Reismanis | Date: | Mon, 06 May 2002 08:58:50 +0000 |
| Subject: | phpMyAdmin Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-96217@lists.php.net to get a copy of this message | ||
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