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 βΒ ~/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 | +------+ | βΒ | +------+ 2011/10/16 Peng Yu <pengyu...@gmail.com>: > Hi, > > I have the greek character "Β" (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=arch...@jab.org