Hello,
I too strict mode off on advice of a post in a forum.
It allowed me to enter the items but they do not go in..
I am using EMS mysql manager sql editor to do it.
This is my variables:
Variable_name
Value
character_set_client
utf8
character_set_connection
utf8
character_set_database
utf8
character_set_filesystem
binary
character_set_results
utf8
character_set_server
utf8
character_set_system
utf8
character_sets_dir
C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\
The SHOW FULL COLUMNS FROM `newsletter`; says the colums are utf8 and the
table is utf8
When I do this statement it basically makes the field blank:
SET NAMES utf8;
SET CHARACTER SET utf8;
update `newsletter` set `newsletter`.`story` = "é û ê à èé û ê à èé û ê à è"
where `newsletter`.`news_id` = 35;
Can anyone shed some light on what I am doing wrong?
--James
----- Original Message -----
From: "James Sherwood" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, November 07, 2007 7:37 PM
Subject: Re: Character encoding problem
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]
__________ 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]
