MySQL 警告:不正确的字符串值:'\x96

问题描述

我正在尝试导入一个 CVS 文件，并在其中收到此警告:1366 不正确的字符串值:'\x96 PART ...' 列

I'm trying to import a CVS file where I get this warning: 1366 Incorrect string value: '\x96 PART...' for column

我在某处读到这是关于 4 位 utf8 字符的.但是将表和列的排序规则更改为 utf8mb4 也不起作用.

I read somewhere that this is about the 4-bit utf8 characters. But changing the collation of the table and column into utf8mb4 didn't work either.

推荐答案

十六进制 96 大概是 en-dash 的 latin1 编码> (–).但是你已经指定了 CSV 文件是 utf8 编码的(或者 utf8mb4)，这个字符是 utf8 无法理解的.

The hex 96 is presumably the latin1 encoding for an en-dash (–). But you have specified that the CSV file is utf8-encoded (or utf8mb4), this character is incomprehensible to utf8.

计划 A:更改文件.(这可能不切实际.)

Plan A: Change the file. (This is probably not practical.)

计划 B:告诉 MySQL 该文件是 latin1(而不是 utf8).然后 MySQL 会将其正确转换为 utf8 编码 E28093.

Plan B: Tell MySQL that the file is latin1 (as opposed to utf8). Then MySQL will convert it correctly to the utf8-encoding E28093.

整理"与排序和比较有关；字符集"与编码"有关.

"Collation" has to do with sorting and comparing; "Character set" has to do with 'encoding'.

将此添加到我假设您正在使用的 LOAD DATA 语句中:

Add this to the LOAD DATA statement that I assume you are using:

CHARACTER SET latin1

参考.

这篇关于MySQL 警告:不正确的字符串值:'\x96的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！