mysql字符集1267问题
来源:互联网 发布:方正排版软件好学吗 编辑:程序博客网 时间:2024/06/06 13:57
今天链接数据库遇到1267错误号,百度之后发现时字符集编码问题。如果数据库数据中有中文,那么字符本身编码应该和mysql客户端编码一致。
ANSI在window下为gbk2312编码
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | gb2312 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gb2312 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\AppServ\mysql\share\charsets\ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)
查看字符集编码:mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| 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命令行修改:
mysql> set character_set_client=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_connection=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_database=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_server=utf8;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_system=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_connection=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_database=utf8;
Query OK, 0 rows affected (0.01 sec)
mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)
- mysql字符集1267问题
- 关于MySql字符集问题
- mysql字符集问题
- MYSQL 字符集问题
- MYSQL 字符集问题
- mysql字符集的问题
- 转:MYSQL 字符集问题
- MYSQL 字符集问题[转载]
- MYSQL 字符集问题
- mysql字符集问题
- MYSQL 字符集问题
- MYSQL 字符集问题
- mysql字符集的问题
- 再谈mysql字符集问题
- mysql 字符集问题
- MYSQL 字符集问题
- MySQL字符集问题
- MYSQL 字符集问题
- 使用plsql导出导入数据库
- 安装MySql 并开放远程访问权限
- C++到底还能做什么?
- linux C 编程 之 进程间通信(IPC)
- maven安装
- mysql字符集1267问题
- IOS开发--收回键盘
- 关于输入多组测试数据,当数据为0时,输入结束
- 使用NSClassFromString
- js数组对象的学习
- mybatis拦截器实现数据库表水平切分
- 最近常用的linux语句
- MAC下安装storm及配置开发环境
- js中2个等号与3个等号的区别