|
|
Posted by NC on 11/13/07 18:40
On Nov 13, 9:45 am, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>
> 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.
And what are the default character sets on the two servers?
> 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.
Which is the Unicode rendition of ’...
> 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.
Another reason to suspect a character set problem...
> In summary: On the destination system all new data will
> display properly. However, old data do not.
>
> Suggestions?
Three: (1) character set, (2) character set, and (3) character set. I
would guess that the source server is configured with Latin-1 (or
similar) default encoding, while the destination server is configured
with UTF-8...
Cheers,
NC
[Back to original message]
|