|
|
Posted by Good Man on 07/18/07 15:58
"Matthew White" <mgw854@msn.com> wrote in
news:H8pni.8062$fj5.7565@trnddc08:
> "Markus" <derernst@NO#SP#AMgmx.ch> wrote in message
> news:469db6f9$1_1@news.cybercity.ch...
>> Matthew White schrieb:
>>
>>> "Rik" <luiheidsgoeroe@hotmail.com> wrote in message
>>> news:op.tvmvq3jkqnv3q9@metallium...
>>>> On Tue, 17 Jul 2007 20:31:56 +0200, Matthew White <mgw854@msn.com>
>>>> wrote:
>>>>
>>>>> I added that query right after calling the database, and it now
>>>>> works fine,
>>>>> but here is a problem- "franais" returns three matches:
>>>>> français
>>>>> française
>>>>> françaises
>>>>>
>>>>> Why is "ç" being substituted for "", even when I pass each
>>>>> returned string
>>>>> through htmlentities()?
>
> I had already made sure of the first and last, but I did add the
> header() to my PHP file. It has made no difference in the output.
Sorry to see this struggle go on for days!
I know some versions of MySQL were buggy with mixing collation types,
and perhaps that is a clue to your problem. Have you looked into using
COLLATE in your SQL query? Not sure if its the right tree to bark up,
but hey, its another tree:
http://dev.mysql.com/doc/refman/5.1/en/charset-collations.html
and then further back,
http://dev.mysql.com/doc/refman/5.1/en/charset.html
good luck
[Back to original message]
|