Dec 6 2009

Learning from your mistakes: mixed character sets in MySQL

Character sets are a big thing these days and luckily we’re slowly evolving to a world where UTF-8 rules. In the meanwhile we’re stuck in a transitional phase where the ISO-8859-1 encoding is still used.

MySQL followed this trend and introduced character set support in version 4.1. Importing data from older versions is easy and SET NAMES ‘utf8′ is quite useful to ensure special characters are correctly encoded in the new databases.

But I learned first hand that the SET NAMES ‘utf8 trick is not a cure for every disease.
Continue reading


Apr 17 2009

Speaking at PHPBelgium user group meeting

Next Wednesday, PHPBelgium is having another user group meeting. This spring edition takes place in Gent again and will feature 2 talks including mine on command line PHP called CLI, the other SAPI.phpbelgium-150x150
Continue reading