Hi! I have an installation of mysql 4.0.20a-nt
I noticed a behavior in column table definitions in phpMyAdmin 2.6.1
I try to add new column in a table using the next sql instruction
alter table xTable ADD newColumn varchar(3) NOT NULL
The operation finishes ok but the configuration of the newColumn field
in the table is char(3) but when I try to define a column as char(n) for n>3
the final column definition is varchar(n).
Has mysql implemented some efficiency strategies for field length in char and varchar variable ?
El Quijote...
