Database character sets and WordPress

We recently upgraded the MySql installation in our emanilapoetry website which is using WordPress 2.8+ install. The upgrade somehow caused a mismatch in the character sets between WordPress and the database tables, the former using a default character set "utf8" and the latter using "latin1." When our technical people tried using WordPress' default character set in the database script, other more serious problems came out. It appears that … [Read more...]