I have recently faced an issue while migrating MySQL to a new server where non-English characters show up as gibberish. This was because UTF-8 text was saved in columns encoded as latin1. The solution is simple, convert the field into a BLOB and then back to text with the required type and encoding.
Fixing Incorrect Encoding In MySQL Databases
2016-05-26 by Mohammad H. Al-Shami
Fixing MySQL Error 1064 With PHPList When Selecting New Criteria
2009-03-14 by Mohammad H. Al-Shami
I’m currently experimenting with PHPlist to use for our corporate newsletters. During the tests I got the following error.