MySQL学习笔记:MySQL ERROR 1300 (HY000): Invalid utf8 character string
来源:互联网 发布:linux grep 命令 编辑:程序博客网 时间:2024/05/29 04:45
验证是否中英混搭导致load数据失败:
建一张test表测试是否是中英混搭
mysql> create table test1 -> (a varchar(32) -> ) -> ;
test.txt
Chinese中文中文;Chinese
test1.txt
中文\Chinesetest2.txt
中文\中文
导入test.txt
mysql> load data local infile "E:/mysql/test.txt" into table test1;Query OK, 3 rows affected (0.08 sec)Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
导入test1.txt
mysql> load data local infile "E:/201506-win/test1.txt" into table test1;Query OK, 1 row affected (0.08 sec)Records: 1 Deleted: 0 Skipped: 0 Warnings: 0导入test2.txt
mysql> load data local infile "E:/201506-win/test2.txt" into table test1;ERROR 1300 (HY000): Invalid utf8 character string: '中文'经过这几个测试发现,中英文字符不存在问题,可以正常插入,导致失败的原因是转义字符“\”后面为中文的问题,像“中文\中文”这样,后面为英文,即“中文\Chinese”是可以正常使用的,插入的记录“\”也没有显示。
1 0
- MySQL学习笔记:MySQL ERROR 1300 (HY000): Invalid utf8 character string
- mysql导入txt类型数据时出现错误 ERROR 1300 (HY000): Invalid utf8 character string: '̨
- windows下txt文件导入mysql出现:ERROR 1300 (HY000): Invalid utf8 character string: ''
- ERROR 1300 (HY000): Invalid utf8 character string: '\xA1\xAF'
- ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
- Error Code: 1300. Invalid utf8 character string: ''
- 将txt文件内容导入mysql中,出现invalid utf8 character string错误的解决
- mysql ERROR 1418 (HY000)
- Mysql ERROR 1289 (HY000)
- mysql ERROR 1206 (HY000)
- MySQL Error 1093(HY000)
- MySQL:ERROR 2002 (HY000)
- mysql ERROR 1290 (HY000):
- MySQL ERROR 1709 (HY000)
- MySQL ERROR 1862 (HY000)
- mysql :ERROR 1820 (HY000)
- MySQL:ERROR 1820 (HY000)
- 解决MySQL里的ERROR 1366 (HY000): Incorrect string value
- AndroidStudio导入错误日志
- Tp使用phpexcel导入导出excel
- IOS学习之——navigationController的界面跳转方法
- 删除排序链表中的重复元素
- 如何安装vmware tools
- MySQL学习笔记:MySQL ERROR 1300 (HY000): Invalid utf8 character string
- 静态缓存案例生成一个html页面
- Linux-shell编程简单程序
- Deep learning 资源
- play-slick基础:CRUD操作
- textView 实现placeholder
- Android 头像上传 相机+图库 绘制圆形头像
- 抚摸被我冷落了一个月的博客の博弈小结
- HDU5583 Kingdom of Black and White(连通块暴力)