MySQL WorkBench导入csv文件出错：‘gbk‘ codec can‘t encode character ‘\ue005‘ in position 6877067: illegal mu

1.第一个问题

Traceback (most recent call last):
  File "test.py", line 112, in <module>
    csv_encoding_transform(
  File "test.py", line 100, in csv_encoding_transform
    csvfile2.write(content)
UnicodeEncodeError: 'gbk' codec can't encode character '\ufeff' in position 0: illegal multibyte sequence

原因：

于是用notepad++打开CSV文件，将编码方式由UTF8BOM改为UTF8

2.第二个问题

Traceback (most recent call last):
  File "test.py", line 112, in <module>
    csv_encoding_transform(
  File "test.py", line 100, in csv_encoding_transform
    csvfile2.write(content)
UnicodeEncodeError: 'gbk' codec can't encode character '\ue005' in position 6877067: illegal multibyte sequence

原因：

写入前将字符\ue005替换为空字符后，成功写入