http://www.mysql.com/doc/S/i/Silent_column_changes.html
second item, quoted here:
If any column in a table has a variable length, the entire row is
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer
than
Alec Solway wrote:
Hi,
In various create table statements char columns are converted to varchar..
I was wondering why this was happening. Here's an example:
CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
null, city VARCHAR(255) not null, state CHAR(2) not
Hi,
Char columns are used with fixed-length type table, whereas varchar are used
with dynamic table. If you have varchar columns in your table, all char
columns will be convert to varchar column (you can't have a fixed-length
table if your table contain varchar, blob or text field).
Here
