ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
来源:互联网 发布:电力系统分析软件 编辑:程序博客网 时间:2024/05/21 22:40
mysql> load data local infile '/tmp/BS_X1.xlsx' into table BS_PROPERTY fields terminated by ',' lines terminated by '\n';
ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
mysql>
【解决办法】:
讲'/tmp/BS_X1.xlsx'的文件格式变换成utf8即可。
1 0
- ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
- ERROR 1300 (HY000): Invalid utf8 character string: '\xA1\xAF'
- 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 Code: 1300. Invalid utf8 character string: ''
- ERROR Unknown character set: 'utf8mb4'
- 【ERROR 1366 (HY000): Incorrect string value】(关键词:字符集/character set)
- String contains an invalid character
- Unknown character set: 'utf8mb4'
- Unknown character set: 'utf8mb4'
- Unknown character set: 'utf8mb4'
- Unknown character set: 'utf8mb4'
- Unknown character set: 'utf8mb4'
- error C2002: invalid wide-character constant
- Syntax error on token "Invalid Character"
- LaTeX:Package CJK Error: Invalid character code
- ERROR 1366 (HY000): Incorrect string value-解决方案
- 分段函数求值 (sdut oj)
- ppt中好多图片重叠在一起了,怎么修改被藏进里面的图片
- JNDI 是什么
- 通用c/c++的Makefile模版
- PAT甲级1051
- ERROR 1300 (HY000): Invalid utf8mb4 character string: 'PK'
- [Codeforces Round #310 DIV1E (CF555E)] Case of Computer Network
- Linux SPI总线和设备驱动架构之二:SPI通用接口层
- 【scikit-learn】交叉验证及其用于参数选择、模型选择、特征选择的例子
- VTK修炼之道26:图像基本操作_三维图像切片提取
- DZ X!插件破解之盗版提示!
- 相似三角形 (sdut oj)
- CODE::BLOCKS 常用快捷键
- windows 安装laravel homestead后,卡在SSH auth method: private key