Shami's Blog

DevOps because uptime is not optional

Fixing Incorrect Encoding In MySQL Databases

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

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.

Categories