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" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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: <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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/[EMAIL PROTECTED]
__________ 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/[EMAIL PROTECTED]
__________ 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/[EMAIL PROTECTED]