Google does not provide any source I would be sure of, many different approaches.. so rather asking here..

Given I have a database with latin1 and some latin* collation, the same for tables and I want to convert database, tables and data to utf8.

Are the following two commands really all I need to do? I mean if that is really enough to change the data as well..

ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

ALTER TABLE db_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Thanks ahead for clarification.

Honza

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to