Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
Directory
alonerhu
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/ |
+--------------------------+----------------------------+
mysql> SHOW VARIABLES LIKE 'collation_%'; +----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
mysql> select * from test;
+--------+
| a |
+--------+
| ?? |
+--------+
now?all are right, but the data in table from ido2db are unreadble?
| 304 | 1 | 3 | cqtel-cpmis | NULL | 1 |
| 305 | 1 | 3 | 信�技术公�软件部 | NULL | 1 |
| 306 | 1 | 3 | �业部档案管� | NULL | 1 |
| 307 | 1 | 4 | 温度监控 | NULL | 1 |
| 308 | 1 | 1 | ITè¿?ç»´kvm1 | NULL | 0 |
| 309 | 1 | 1 | ITè¿?ç»´kvm2 | NULL | 0 |
| 310 | 1 | 1 | NFSå˜å‚¨ | NULL | 0 |
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
mysql> SHOW VARIABLES LIKE 'collation_%'; +----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+----------------------+-----------------+
mysql> select * from test;
+--------+
| a |
+--------+
| ?? |
+--------+
now?all are right, but the data in table from ido2db are unreadble?
| 304 | 1 | 3 | cqtel-cpmis | NULL | 1 |
| 305 | 1 | 3 | 信�技术公�软件部 | NULL | 1 |
| 306 | 1 | 3 | �业部档案管� | NULL | 1 |
| 307 | 1 | 4 | 温度监控 | NULL | 1 |
| 308 | 1 | 1 | ITè¿?ç»´kvm1 | NULL | 0 |
| 309 | 1 | 1 | ITè¿?ç»´kvm2 | NULL | 0 |
| 310 | 1 | 1 | NFSå˜å‚¨ | NULL | 0 |