Re: How to know that foreign characters are being inserted as utf-8?
Posted by: Peter Gulutzan
Date: January 17, 2010 11:33AM

Hi,

Start by checking the MySQL Reference Manual
http://dev.mysql.com/doc/refman/5.5/en/faqs-cjk.html
in the section
"I have inserted CJK characters into my table. Why does SELECT display them as “?” characters?"
Continue by checking the many many instances on this forum
where variants of this same question have been asked.

The first two strings have characters which are in most character sets
including latin1. The third string is pure Greek. If your 'foreign'
characters are "being inserted as utf8", and your display is utf8,
you will see this on a terminal with mysql:

mysql> select 'Ελληνικά',hex('Ελληνικά');
+------------------+----------------------------------+
| Ελληνικά | hex('Ελληνικά') |
+------------------+----------------------------------+
| Ελληνικά | CE95CEBBCEBBCEB7CEBDCEB9CEBACEAC |
+------------------+----------------------------------+
1 row in set (0.00 sec)



Peter Gulutzan
MySQL / Sun

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to know that foreign characters are being inserted as utf-8?
2219
January 17, 2010 11:33AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.