Re: Converting existing database

[Alexander Barkov]

This command converts all CHAR, VARCHAR and TEXT columns
at once:

ALTER TABLE t1 CONVERT TO CHARACTER SET utf8;


You can also specify desired collation and the same time:

ALTER TABLE t1 CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;