Talk:TIP Convert latin1 to UTF-8 in MySQL

From Gentoo Linux Wiki

Jump to: navigation, search

Under the heading "Convert dump" - isn't it also necessary to replace all references to 'latin1' in the dump to 'utf-8'? My dump (from external source) has lots of 

CREATE TABLE `bla` (....) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Wouldn't this then cause the imported tables to be in latin1 again anyway? --02:10, 28 March 2008 (UTC)

It seems the parameter --skip-set-charset should perhaps be given to mysqldump to stop it from adding these directives in the dump. For people that can't redo the dump (external source) it might be necessary to sed the latin1 to utf-8. Can somebody confirm, perhaps? --02:16, 28 March 2008 (UTC)


What about this command? 

ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

--Artem

Retrieved from "http://gentoo-wiki.com/Talk:TIP_Convert_latin1_to_UTF-8_in_MySQL"
Personal tools