UTF-8 and character 0xC4B7
I have problem with inserting tajik character 'ķ' (0xC4B7) and some others.
MySQL converts them to 0x3F (question mark).
Other characters (ukrainian, russian, turkish) inserts correctly.
Any ideas ?
mysql> show variables like '%colla%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)
mysql> show variables like '%char%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+
7 rows in set (0.00 sec)
mysql> show variables like '%version%';
+-------------------------+----------------------------------------------------------+
| Variable_name | Value |
+-------------------------+----------------------------------------------------------+
| protocol_version | 10 |
| version | 4.1.11 |
| version_bdb | Sleepycat Software: Berkeley DB 4.1.24: (April 1, 2005) |
| version_comment | FreeBSD port: mysql-server-4.1.11_1 |
| version_compile_machine | i386 |
| version_compile_os | portbld-freebsd5.2.1 |
+-------------------------+----------------------------------------------------------+
6 rows in set (0.00 sec)
Subject
Views
Written By
Posted
UTF-8 and character 0xC4B7
2732
June 08, 2005 08:00AM
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.