ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column 'tname' at row 1
来源:互联网 发布:python 读取配置文件 编辑:程序博客网 时间:2024/05/15 02:45
在mysql中插入中文字段的时候会提示下面报错
mysql> insert into tutors values(32,'中国','M',21);
ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column 'tname' at row 1
这是由于没有设置编码
mysql> set names latin1;
Query OK, 0 rows affected (0.00 sec)
(latin1可以用gdk等编码)
0 0
- ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column 'tname' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'name' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\x8D\xE5\xA5\xBD' for column 'description' at r
- 1366 - Incorrect string value: '\xE4\xB8\xAD\xE6\x96\x87' for column 'cName' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
- Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'xxx' at row 1
- 错误信息:Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'name' at row 1
- Incorrect string value: '\xE4\xB8\xAD\xE7\xBA\xA7' for column 'title' at row 1
- Incorrect string value: '\\xE7\\x9B\\xB8\\xE5\\x90\\x8C...' for column 'comment' at row 1
- failed:Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
- MySQL 执行插入操作时报1366 - Incorrect string value: '\xE4\xB8\xAD\xE6\x96\x87' for column 'name' at row 1
- Incorrect string value: '\xE4\xB8\x80\xE7\xBA\xA7...' for column 'name' at row 1
- 汉字十六进制编码转换\xe4\xb8\xad\xe5\x9b\xbd
- Incorrect string value: '\xE4\xBC\x9A\xE5\x91\x98' for column 'recipient' at row 1
- mysql:Incorrect string value: '\xE5\x8C\x97\xE4\xBA\xAC' for column 'address' at row 1
- Incorrect string value: '\xE5\x9E\x9A\xE5\x9B\xBD...' for column 'YD_COMPANY
- node.js Incorrect string value: '\xF0\x9F\x92\x9E\xE5\x9B...' for column 'nickname' at row 1
- ctags的简单使用
- java导入导出Excel poi跟jxl
- mac 下使用 minicom 进行串口调试
- Android仿qq下拉刷新及向左滑动列表----PullToRefresh, SwipeMenuListView开源项目整合
- 用GDB调试程序(二)
- ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column 'tname' at row 1
- PHPCMS动态调用导航菜单
- 用GDB调试程序(三)
- Lombok------Spice up your java(消除冗长的Java代码)
- oracle 存储过程的基本语法
- UITableView 分隔线的自定义方法(可自定义分隔线的颜色 粗细 与屏幕边缘的距离)
- LoadrRunner报错-Error: The table 'F:\测试脚本\loadrunner\toutTest3\NewParam.dat' does not exist.
- mysql查看数据库表的创建时间
- 用GDB调试程序(四)