Warning: Missing argument 2 for wp_kses(), called in /var/www/wphost/wp-content/plugins/bsocial/components/open-graph.php on line 175 and defined in /var/www/wphost/wp-includes/kses.php on line 476

Converting MySQL Character Sets

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.

User contributed tags for this post: