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

After I dump the database in and change everything to utf8(or if I try to 
dump and make them all utf8 on the dump) I get  an "incorrect string value" 
error when trying to put french characters in.

Any ideas?.

--James
----- Original Message ----- 
From: "James Sherwood" <jsherwood@stripped>
To: <mysql@stripped>
Sent: Wednesday, November 07, 2007 6:16 PM
Subject: Re: Character encoding problem


> 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
>>
>>
>
>
> -- 
> 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