I try to have CHAR and TEXT in the same table but the CHAR is automatically converted to VARCHAR. I am using MySQL.
Any ideas?
Thanks / Henrik
How do you define the CHAR fields?
I am using MySQL-FRONT to add and update fields.
And when you define a field as CHAR, mysql_front changes it into varchar?
yes
Did you try doing it by hand instead?
This didn't work;
ALTER TABLE list CHANGE defaultmail defaultmail CHAR(60)
And what was the error?
no error, no changes
That's very strange. Can you add a new column of the correct type?
no everyone becomes VARCHAR
