gistfile1.txt

Just for everyone's information, if you want to run purely utf8, don't forget the following:

httpd.conf:
AddCharset UTF-8 .utf8
AddDefaultCharset UTF-8

php.ini
default_charset = "utf-8"

my.cnf
character-set-server=utf8
default-collation=utf8_unicode_ci

Then, if you're writing PHP scripts, soon after opening your connection to mysql, issue one of the following:
SET NAMES 'utf8';
OR, if you are running the mysqli extension:
mysqli_set_charset('utf8');