MySQL Forums
Forum List  »  Connector/Python

UTF-8 query differs between CLI and phpMyAdmin
Posted by: gattu marrudu
Date: April 07, 2008 03:00PM

Hi,
I'm quite a newbie with MySQL but I read how to use UTF-8 in MySQL.
The database I'm working on is in UTF-8 already, as well as my server:


mysql> show variables like '%character%'; 
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       | 
| character_set_connection | utf8                       | 
| character_set_database   | utf8                       | 
| character_set_filesystem | binary                     | 
| character_set_results    | utf8                       | 
| character_set_server     | utf8                       | 
| character_set_system     | utf8                       | 
| character_sets_dir       | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

Now, if I enter this query on the php command line:


UPDATE gallery_sections SET comments_it='èè' WHERE id='1';

If I then select that column, the new value appears correctly.
But if I look at the table on phpMyAdmin, I see "èè" instead of "èè".

I have the same problem if I send the query through an HTML form (the page is UTF-8 encoded too) processed with PHP.

How can that be? Is there something I am missing?

Thanks for your help
gm

Options: ReplyQuote


Subject
Written By
Posted
UTF-8 query differs between CLI and phpMyAdmin
April 07, 2008 03:00PM


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.