Re: How to know that foreign characters are being inserted as utf-8?
Posted by: El Duce
Date: January 19, 2010 11:24AM

Peter Gulutzan Wrote:
-------------------------------------------------------
> Hi,
>
> Start by checking the MySQL Reference Manual
> http://dev.mysql.com/doc/refman/5.5/en/faqs-cjk.ht
> ml
> 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


Thanks for the response. In the terminal if I do a query the words show up like this Espa▒ol Fran▒ais ???????? Portugu▒s T▒rk▒e ??▒▒?▒? | <p>Espa▒ol

When I run what you suggested
select 'Ελληνικά',hex('Ελληνικά');

It displays them properly. Does this mean those characters in the database are still not being saved as utf8?

Options: ReplyQuote


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


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.