|
|
Posted by The Natural Philosopher on 11/13/07 17:54
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?
Stucklehead will probably come along and tell you all you never wanted
to know..
Navigation:
[Reply to this message]
|