Shami's Blog

Sysadmin, Because Even Developers Need Heroes

Fixing Incorrect Encoding In MySQL Databases

2016-05-26 by Mohammad H. Al-Shami

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.

Read More...

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.

Read More...