Dec
6
2009
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
1 comment | tags: --skip-extend-insert, character set, charset, database, encoding, iconv, iso, ISO-8859-1, migration, mixed, MySQL, mysqldump, php, preg_match, regex, regular expression, set names, set names utf8, skip extended insert, utf-8, utf8, utf8_encode | posted in MySQL, PHP
Mar
3
2009
It’s been a while since I last attended an international conference. In fact, my last one was the unforgetable 2008 Dutch PHP Conference. It was also my first time at the London conference. It actually turned out to be a great one, hence this review.
Continue reading
2 comments | tags: conference, drizzle, felixdv, ibuildings, london, MySQL, php, phpuk2009, security, sharding, shiflett | posted in PHP
Jan
10
2009
Hello world!
This seems like an “out of the box” post and you might be wondering where the “lorem ipsum” is. But no, this is my official hello to the world because my blog is online again and in this time I’ll do it in English for the logical purpose of reaching more people.Continue reading
2 comments | tags: apache, felixdv, hello world, LAMP, linux, MySQL, php, seven things, ThijsFeryn, twitter | posted in General
Recent Comments