之前的 LOAD DATA INFILE
是在假设 CSV 文件是 latin1
编码的情况下运行的.在此导入过程中,多字节字符被解释为两个单个字符,然后(再次)使用 utf-8 进行编码.
A previous LOAD DATA INFILE
was run under the assumption that the CSV file is latin1
-encoded. During this import the multibyte characters were interpreted as two single character and then encoded using utf-8 (again).
这种双重编码产生了像±
而不是这样的异常.
This double-encoding created anomalies like ±
instead of .
如何更正这些字符串?
下面的MySQL函数会在双重编码后返回正确的utf8字符串:
The following MySQL function will return the correct utf8 string after double-encoding:
CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8)
它可以与 UPDATE
语句一起使用以更正字段:
It can be used with an UPDATE
statement to correct the fields:
UPDATE tablename SET
field = CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8);
这篇关于如何修复双重编码的 UTF8 字符(在 utf-8 表中)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!