Thanks for the info,
For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted to
that I beleive.
Is there a way to dump it to utf8?
----- Original Message -----
Sent: Wednesday, November 07, 2007 4:23 PM
Subject: Re: Character encoding problem
> James Sherwood wrote:
>> We are trying to upgrade from 4.0 to 5 and we are not having any luck on
>> the character sets.
>> We need to use French characters for some things.
>> We have tried setting utf8 for everything we can find but the characters
>> still show all screwed up..
>> I have read the manual regarding all the variables and have placed all I
>> can in the my.ini etc.
>> Can someone who has it working post the relevant info from their ini file
>> along with any help for other setting we need to change?
> Are you referring to data that is inserted via the client? If so, make
> sure to issue the following upon connecting:
> SET NAMES utf8;
> SET CHARACTER SET utf8;
> Was this dumped from the version 4.x DB? Are you sure that it really is
> If this is a web app, do you see any difference betwen the browser and a
> terminal? If you're looking at it through a browser, ensure that the
> correct character set header is sent out.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> __________ NOD32 2644 (20071107) Information __________
> This message was checked by NOD32 antivirus system.