Hi,

I just realized that the problem is that I also need to specify
charset for load data. Once the utf8 is specified for 'load data',
then the problem is solved. Please ignore my previous email. Thanks!

~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat main.sql
use test
CREATE TEMPORARY TABLE test (
name VARCHAR(255) character set utf8
);
LOAD DATA LOCAL INFILE 'table.txt' INTO TABLE test CHARACTER SET utf8;
SELECT * FROM test;
~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat table.txt
=E2=C2
~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ cat main.sh
#!/usr/bin/env bash

mysql -t -hlocalhost -uxxx < main.sql

~/linux/test/mysql/mysql/LOAD_DATA/CHARACTER_SET$ ./main.sh
+------+
| name |
+------+
| =E2=C2 |
+------+


2011/10/16 Peng Yu <pengyu.ut@gmail.com>:
> Hi,
>
> I have the greek character "=C2" (not that it is different from the
> English character "B", although they look similar. Copy both of them
> and type in google search box, you will see different search
> suggestion pop up).
>
> utf8 in mysql seems doesn't work. I'm wondering what charset I should
> for this greek letter.
>
> --
> Regards,
> Peng
>



--
Regards,
Peng

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com