What charset to use for greek character Â?

What charset to use for greek character Â?

am 17.10.2011 05:25:49 von PengYu.UT

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.

--=20
Regards,
Peng

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: What charset to use for greek character Â?

am 17.10.2011 06:06:01 von PengYu.UT

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 :
> 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
>



--=20
Regards,
Peng

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg