I'm having problems when configuring a server with UTF8. Well, I'm not configuring it exactly. I client from where I work does and I think that he's not an expert configuring web servers.
My PHP+MySQL application needs to use Apache and MySQL in UTF8. After various e-mails, this person configured apache with utf8 support but now it's time to MySQL and there is no way we can configure it. I don't know what to do because I'm not a system administrator but I configured apache/mysql on ubuntu with utf8 support looking into Google.
What I said to him is that please, use the next configuration on my.cnf:
[mysqld] character-set-filesystem=UTF8 character-set-server=UTF8 default-collation=UTF8_general_ci default-character-set=UTF8 [client] default-character-set=UTF8 [mysqldump] default-character-set=UTF8
But nothing changed. He passed me the my.cnf that is running, you can see it here: http://pastebin.com/NfcgKKiM ... and doesn't works the UTF8 encoding on MySQL.
What I did in PHP is launch a MySQL query every time with
SET NAMESutf8`` and it works as UTF8 but I don't think that is the best option but proves that something is miss configured. No?
What I can do? What I can say to the server admin?
Thank you and sorry for my bad English!