List:General Discussion« Previous MessageNext Message »
From:James Sherwood Date:November 7 2007 10:16pm
Subject:Re: Character encoding problem
View as plain text  
Hello,

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?

--James

----- Original Message ----- 
From: <mysql@stripped>
To: <mysql@stripped>
Sent: Wednesday, November 07, 2007 4:23 PM
Subject: Re: Character encoding problem


> James Sherwood wrote:
>> Hello,
>>
>> 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 
> UTF-8?
>
> 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.
>
> brian
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: 
> http://lists.mysql.com/mysql?unsub=1
>
>
> __________ NOD32 2644 (20071107) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
> 

Thread
Trigger problemLucky Wijaya7 Nov
  • Re: Trigger problemDavid Schneider-Joseph7 Nov
    • Re: Trigger problemLucky Wijaya7 Nov
      • Re: Trigger problemDavid Schneider-Joseph7 Nov
        • Character encoding problemJames Sherwood7 Nov
          • Re: Character encoding problemmysql7 Nov
            • Re: Character encoding problemJames Sherwood7 Nov
              • Re: Character encoding problemJames Sherwood8 Nov
                • Re: Character encoding problemJames Sherwood8 Nov
              • Re: Character encoding problemmysql8 Nov
                • Character encoding problem STILLJames Sherwood9 Nov
                  • Re: Character encoding problem STILLAnanda Kumar9 Nov
        • Re: Trigger problemLucky Wijaya9 Nov
          • Re: Trigger problemScott13 Nov