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...

About Me

Dev gone Ops gone DevOps. Any views expressed on this blog are mine alone and do not necessarily reflect the views of my employer.