问题:Incorrect string value: '\xE5\xAE\x89\xE5\x8D\x93...' for column 'use_device' at row 1
来源:互联网 发布:php 系统自带空类 编辑:程序博客网 时间:2024/04/28 06:58
在编程时遇到的问题,对数据库插入中文字符时报错
错误提示:Incorrect string value: '\xE5\xAE\x89\xE5\x8D\x93...' for column 'use_device' at row 1
解决方案:更改数据库表的字段名
方法:
1、ALTER TABLE`tablename` CHANGE `字段名1` `字段名2` VARCHAR(36) CHARACTERSET utf8 NOT NULL;(一次修改一个字段)
2、alter table `tablename` convert to character set utf8;(修改整张表的所有字段名,注意这里的tablename是表名)阅读全文
1 0
- 问题:Incorrect string value: '\xE5\xAE\x89\xE5\x8D\x93...' for column 'use_device' at row 1
- Incorrect string value: '\xE5\x93\x88\xE5\x93\x88' for column 'keyword' at row 1
- failed:Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
- Incorrect string value: '\xE4\xBD\xA0\xE5\xA5\xBD' for column 'xxx' at row 1
- Incorrect string value: '\xE4\xBC\x9A\xE5\x91\x98' for column 'recipient' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
- Incorrect string value: '\xE7\x94\x98\xE5\xB7\x9E...' for column 'SystemName' at row 1
- mysql:Incorrect string value: '\xE5\x8C\x97\xE4\xBA\xAC' for column 'address' at row 1
- Incorrect string value: '\\xE7\\x9B\\xB8\\xE5\\x90\\x8C...' for column 'comment' at row 1
- Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' 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 'name' at row 1
- Sqlyog中解决编码问题Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- MySQL-修改表的编码和列的编码-Incorrect string value: '\xE6\xB1\x9F\xE5\xAE\x81...' for column 'unitname' at row
- ERROR 1366 (HY000): Incorrect string value: '\xE4\xB8\x8D\xE5\xA5\xBD' for column 'description' at r
- Mysql 插入中文错误:Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1
- 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
- AI那点事儿
- IOS苹果内支付iap Java服务端
- Linux系统下安装rz/sz命令及使用说明
- 微信小程序获取指定页面的二维码
- ImageLoader源码详解
- 问题:Incorrect string value: '\xE5\xAE\x89\xE5\x8D\x93...' for column 'use_device' at row 1
- Servlet 初步
- 使用CATransaction实现push pop控制器结束的回调
- Java foreach和for对不同数据结构的效率
- 一步一步理解线段树
- 用代码向视图控制器里输入想要的表格单元格内容
- android studio 与gradle的版本对应
- R聚类算法-层次聚类算法
- 【python】小甲鱼入门课程错题整理