Re: Upgrading from 4.0 to 4.1

[Alexander Barkov]

If you have a 4.0 table:

CREATE TABLE x (column varchar(150)) with utf8 data and want to upgrate to 4.1,

do these two steps following:

ALTER TABLE t1 MODIFY column VARBINARY(150);
ALTER TABLE t1 MODIFY column VARCHAR(150) CHARACTER SET utf8;

The first step will remove wrong assumption that character set it latin1 (which is default),
the seccond step will assign correct character set. Data will not be touched.

If you do it in a signle query, it tries to convert from latin1 to utf8, which is
not something desired.