alonerhu

can it support utf8 for chinese

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 |

Reviewed 14 years ago