Build precise queries to find exactly what you need
Press ESC to close
Nagios World Conference 2026: Sept. 14-17 in St. Paul, MN | Learn More
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 |