> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Baron Schwartz > Sent: Friday, January 18, 2008 2:33 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Handling Special Characters > > Jerry, > > On Jan 18, 2008 2:27 PM, Jerry Schwartz <[EMAIL PROTECTED]> > wrote: > > I am having trouble inserting special characters into a table. I am > using > > the MySQL client. I put the following commands into a text file (I'm > on > > WinXP, using Notepad), copy them, and paste them into the MySQL > command line > > client. > > > > SET NAMES utf8; > > > > CREATE TEMPORARY TABLE `giiexpr_db`.`eo_name_table` ( > > `eo_name` VARCHAR( 255 ) NOT NULL > > ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; > > > > INSERT INTO eo_name_table > > (eo_name) > > VALUES > > ("Associated British Foods Plc (Abf) - Hot Drinks - World"); > > > > SELECT * FROM eo_name_table; > > +---------------------------------------------------------+ > > | eo_name | > > +---------------------------------------------------------+ > > | Associated British Foods Plc (Abf) - Hot Drinks - World | > > +---------------------------------------------------------+ > > 1 row in set (0.04 sec) > > > > That symbol before "World" is an N-dash, 0x96. This works perfectly. > > > > Here's where things go wrong. If instead of pasting these commands > into the > > client, I source the exact same file, I get this: > > > > +-------------------------------------------------+ > > | eo_name | > > +-------------------------------------------------+ > > | Associated British Foods Plc (Abf) - Hot Drinks | > > +-------------------------------------------------+ > > 1 row in set (0.04 sec) > > > > It seems that special characters are treated differently when they > are in a > > sourced file. It isn't just the N-dash, French accented characters > cause the > > same problem. These are all single-byte characters. > > > > Just to be sure, I checked the length of the string in the field, and > it > > accurately reflected the difference. That proves, to my satisfaction, > that > > the problem is on the input side. > > > > I'm using version 4.1.22 community server on a Linux platform. I'm > using > > version 5.0.45 of the CLI client. > > > > Anyone have any ideas? I was trying to avoid having to write a > program to do > > this. > > After you get the data you want into the table via copy/paste, can you > dump and reload it correctly with mysqldump > dump.sql and mysql < > dump.sql? If so, try peeking into the dump file and see how it's > written there. [JS] Just to make things more complicated, I've discovered that pasting in 0x96 works fine, pasting in an e-acute does not.
I'll try your suggestion. This has been driving me nuts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
