UTF-8 and character 0xC4B7
Posted by: Sergey Prikhodko
Date: June 08, 2005 08:00AM

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)

Options: ReplyQuote


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.