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