Bits and pieces of John Dalton from all over your internet.

Getting out of MySQL Character Set Hell

April 29 2010, 12:29am

Excellent detailed analysis of problems caused by mixing character set encodings within a table, and what to do about it.

"Since I wasn’t able to find any other authoritative source on this on the internet (and in fact, most of the other sources I’ve seen have said you really don’t want to be in this situation– while offering little help as to what to do about it if you’re already there), I thought writing a public document on the subject might help some other systems administrators out there who do find themselves unexpectedly in the middle of MySQL Character Set Hell."