Archive for the ‘MySQL’ Category

Converting a MySQL database to UTF-8

Wednesday, April 16th, 2008

I occasionally need to convert a mysql database to UTF-8. This can be a painful process and if it goes wrong can result in a nightmare of character-set collisions. Some digging around on the lazyweb led me to a nice solution I found over at oscarm.org that shows you how to quickly convert the actual data, but I wanted to convert the database too.

(more...)