joined:Oct 30, 2013
I'm having some troubles with a simple SELECT query in PHP + MySQL.
The problems start when I search for string like 'Curaçao' or 'Saint Barthélemy' to mention a few. The problems are the letters 'ç' and 'é'.
Fields, tables, database, connection, charset on the page that display the result are set utf8_unicode_ci.
I tried all the solution that I found but I cannot make it work and few hours of fruitless attempts I have to post a new question.
I also try straight in the phpMyAdmin to use this query SELECT nationFlag FROM tbnations WHERE nation LIKE _utf8 "Curaçao" COLLATE utf8_unicode_ci and the result of the query is empty
[edited by: engine at 11:14 am (utc) on Sep 3, 2014]