Yes, I tracked down the root cause on my end: some WP’s database tables are using the legacy (pre-WP 2.2) "CHARACTER SET
latin1" instead of the new "CHARACTER SET
utf8". Now I am scratching my head: how (with least efforts) to convert the database character sets from latin1 to utf8? There are too many choices...
The WP codex article "
Converting Database Character Sets" is dated 2010 and describes a very manual and a very involved method;
The "
UTF-8 Database Converter" plugin is dated 2010 and is no longer being maintained by the author; it uses behind the scene the SQL statements:
PHP Code:
ALTER DATABASE $db CHARACTER SET utf8
ALTER TABLE $table CONVERT TO CHARACTER SET binary
ALTER TABLE $table CONVERT TO CHARACTER SET utf8
ALTER TABLE $table MODIFY $field_type $field_options
OPTIMIZE TABLE $table
The "
Convert WP Database to UTF-8" plugin is dated 2011; it uses behind the scene the SQL statements:
PHP Code:
ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE $table CHANGE $field_name $field_name $field_type CHARACTER SET utf8 COLLATE utf8_general_ci
THen there is
Alex King's blog about latin1 to utf8 conversion dated 2008...