- 论坛徽章:
- 9
|
本帖最后由 stupid_lee 于 2015-09-18 16:28 编辑
mysql显示韩文乱码
xxxxxxxxxx:/root>echo $LANG
en_US.UTF-8- show variables like '%chara%';
- +--------------------------+-----------------------------------+
- | 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 | /usr1/mysql/5617a/share/charsets/ |
- +--------------------------+-----------------------------------+
- 8 rows in set (0.00 sec)
复制代码 默认建表也是utf8
ENGINE=InnoDB AUTO_INCREMENT=30064220 DEFAULT CHARSET=utf8
xshell 字符集也调整为了 UTF8
但是某个存储韩文的字段总是乱码
select c_charname from t_char_basic limit 1;
+------------+
| c_charname |
+------------+
| 넥슨 | 我贴到论坛是显示正常的,应该问题出现在xshell 上了,但是xshell字符怎么调都不对。。。
+------------+
1 row in set (0.00 sec)
求破解 |
|