This Gentoo Wiki page suggests dumping the table and using iconv to convert the characters, then insert the dump into a new table with the new charset.

Alex King solved a different problem: his apps were talking UTF8, but his tables were Latin1. His solution was to dump the tables, change the charset info in the dump file, then re-insert the contents.

Posted October 9, 2008 by Casey
Categories: Technology. Tags: character encoding, character set, character set conversion, latin1, mysql, utf8.

No Comments Yet

No comments yet.

Comments RSS TrackBack Identifier URI

User contributed tags for this post: