Posted by Matthew White on 07/17/07 13:52

Soundex might work, but the MySQL documentation you provided clearly states:

Important: When using SOUNDEX(), you should be aware of the following
limitations:
This function, as currently implemented, is intended to work well with
strings that are in the English language only. Strings in other languages
may not produce reliable results.
This function is not guaranteed to provide consistent results with strings
that use multi-byte character sets, including utf-8.

Thanks for your help, though!
Matt

"Harrie Verveer"
<harrie-remove_this_and_the_-_between_i_and_b@i-buildings.nl> wrote in
message news:aeqdnarFfYR-6wHbRVnyhAA@zeelandnet.nl...
> Hi Matthew,
>
> you might want to look into soundex functions:
>
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex
>
> Kind regards,
>
> Harrie Verveer
>
> Matthew White 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
>>
>>
>>
>>

[Back to original message]