Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

phpmyadmin fehler rechte unerlaubte mischung, WWWXXXApc, lilo trying to map files from unnamed device 0x0000", Wwwxxxapc, CAM::PDF::Renderer::TextF Fragen, adodb.recordset error '800a0cc1', php save mails as eml, WWWXXXAPC, sqlexpress database file auto-creation error, sqlexpress database file auto-creation error

Links

XODOX
Impressum
Datenschutz

#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