Character encoding fix with PHP, MySQL 5 and ubuntu-server
For some reason, under ubuntu-server, my default MySQL 5 character encoding was latin1. This caused no end of problems with grabbing data from the web, which was not necessarily in latin1 characterset. If you are ever in this situation, I suggest you handle everything as UTF-8. That means setting the following lines in my.cnf: [mysqld] .. default-character-set=utf8 skip-character-set-client-handshake If you already have tables in your database that you have created, and they have defaulted to the latin1 charset, you’ll be able to tell by looking at the mysqldump SQL: ...