Re: Going all UTF-8

[Shuichi Tamagawa]

Rickard Andersson wrote:
> OK. So if I change the character set of the table,
> all the existing column will be converted?

Yes.

Note that the following command doesn't convert anything.

ALTER TABLE table_name DEFAULT CHARACTER SET = utf8;

If you want to convert the table definition and data of the existing table, do

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8;

Like KimSeong said, make sure that you take backup before doing that. And do it on testing environment first. Character set conversion always has some risks.