Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: What charset to use for greek character Â?

Posted on 2011-10-17 05:25:49 by 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

Report this message

#2: Re: What charset to use for greek character Â?

Posted on 2011-10-17 06:06:01 by 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 <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
>



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

Report this message