Posted by Shelly on 11/13/07 18:41

The Natural Philosopher wrote:
> Shelly wrote:
>> I am running into a character problem and I am seeking a little
>> advice. The client is moving his code from one server to another. The
>> destination server has MySQL 4.0.7 and the host will not upgrade. The
>> source server has MySql 4.1.22.
>>
>> On the source server a string with an apostrophe that was written to
>> the database displays properly. Porting those data to the
>> destination site, and using the same code, produces strange results.
>> For example, the apostrophe (value=39) displays as the characters
>> for the sequence with values of 226, 128, 153.
>>
>> If I put in a new string with an apostrophe via php code on the
>> destination server, then retrieval of that string displays properly
>> there. For the old strings I have tried stripslashes, but this had no
>> effect. This is not the only situation. The word cafe, for example, with
>> the
>> (whatever-kind-it-is) accent also displays poorly ont the destination
>> server.
>>
>> In summary: On the destination system all new data will display
>> properly. However, old data do not.
>>
>> Suggestions?
>>
> I suspect its not the age of the Mysql, but a php/mysql config issue.
>
> Is it magicl sashes?

When I look at the data via phpMyAdmin, I see an apostrophe. When I expand
the result I fetch via php code, it shows that sequence.

>
> Stucklehead will probably come along and tell you all you never wanted
> to know..

I doubt it. He thinks I am lazy and "stoooopid". Oh, and a performation in
a donkey. But, I'll welcome any and all helpful hints.

--
Shelly

[Back to original message]