Re: set names 'utf8'

[Banzai 301]

Shuichi Tamagawa :

Thank you. This was HIGHLY helpful.

I was working on a web app with spanish characters with accents, and I had gone for ut8 everywhere (webpages, db charset and collation) however I had the following problems :

- when browsing the db with phpmadmin the accented characters would not display correctly (they were fine when retrieved and display on my web pages with php), which I found suspect. For instance I would see 'é' instead of 'é', or 'ñ' instead of 'ñ'.

- searches (select statements) with MATCH AGAINST or LIKE would not be accent insensitive, which was a problem (and it was supposed to be with the choosen collation).

In the end I ran the "show variables like 'character_set%';" and saw that "character_set_server" was latin1.

That's were I found your recommendation and added the "mysql_query("SET NAMES 'utf8'");" to my php db connection code.

What a relief. I had to reenter the data in the DB but everything is working as expected now...

Thanks again.