Posted by Matthew White on 07/17/07 18:31

I added that query right after calling the database, and it now works fine,
but here is a problem- "français" returns three matches:
français
française
françaises

Why is "ç" being substituted for "ç", even when I pass each returned string
through htmlentities()?

Matt

"eisenstein" <stefan.huwiler@gmail.com> wrote in message
news:1184661891.783545.164920@d30g2000prg.googlegroups.com...
On 16 Jul., 23:31, "Matthew White" <mgw...@msn.com> wrote:
> Hello,
> I have a website that is supposed to grab a French word, and return the
> English translation. The front-end has an AJAX script, that dynamically
> POST's the value to the backend:
>
> function post() {
> var string = document.getElementById("string").value;
> var poststr = "string=" + encodeURI( string );
> makePOSTRequest('dict.eng.php', poststr);
> }
>
> Then the backend takes the script, and queries a database for 30 words
> most
> like that word:
>
> $query = "SELECT * FROM dictionary WHERE fr like ('" . $string . "%')
> ORDER
> BY fr LIMIT 30";
> $query = mysql_query($query);
>
> If I enter in a word like "bonjour", the script returns the words that are
> most like bonjour. A word with a special character, like "français", will
> return no values, even though it is in the dictionary. The page is in
> UTF-8, and the database, tables, and fields are all utf8_bin. Can anyone
> please point me in the right direction?
>
> Matt

Try to define first the connection encoding as utf8 (SET NAMES utf8),
before doing any db-transaactions.
Be aware that not all php-functions can handle unicode data strings:

mysql_query("SET NAMES 'utf8'");

eisenstein

[Back to original message]