我得到这个错误如何解决这个?
错误未处理的异常:'charmap'无法解码位置2890中的字节0x9d。Char映射到undefined
我做了所有必要的步骤在mysql工作台导入csv文件，但在选择utf 8编码时得到上述错误
这是日志文件的内容
# Copyright (c) 2014, 2018, Oracle and/or its affiliates. All rights
reserved.
#
# This program is free software; you can redistribute it and/or
modify
# it under the terms of the GNU General Public License, version 2.0,
# as published by the Free Software Foundation.
#
# This program is also distributed with certain software (including
# but not limited to OpenSSL) that is licensed under separate terms, as
# designated in a particular file or component or in included license
# documentation. The authors of MySQL hereby grant you an additional
# permission to link the program and your derivative works with the
# separately licensed software that they have included with MySQL.
# This program is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See
# the GNU General Public License, version 2.0, for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
import grt
import os
import traceback
def log_error(msg):
tb = traceback.extract_stack(limit=2)
grt.log_error("%s:%s:%s"%(os.path.basename(tb[-2][0]),tb[-2][2],tb[-2][1]), msg)
def log_warning(msg):
tb = traceback.extract_stack(limit=2)
grt.log_warning("%s:%s:%s"%(os.path.basename(tb[-2][0]),tb[-2][2],tb[-2][1]), msg)
def log_info(msg):
tb = traceback.extract_stack(limit=2)
grt.log_info("%s:%s:%s"%(os.path.basename(tb[-2][0]),tb[-2][2],tb[-2][1]), msg)
def log_debug(msg):
tb = traceback.extract_stack(limit=2)
grt.log_debug("%s:%s:%s"%(os.path.basename(tb[-2][0]),tb[-2][2],tb[-2][1]), msg)
def log_debug2(msg):
tb = traceback.extract_stack(limit=2)
grt.log_debug2("%s:%s:%s"%(os.path.basename(tb[-2][0]),tb[-2][2],tb[-2][1]), msg)
def log_debug3(msg):
tb = traceback.extract_stack(limit=2)
grt.log_debug3("%s:%s:%s"%(os.path.basename(tb[-2][0]),tb[-2][2],tb[-2][1]), msg)
我有一个类似的问题，并找到了一个解决方案，也许这将有助于。在记事本上打开csv文件，可以看到ASCII所使用的内容。我的是UTF8 BOM，只需将其更改为UTF8就解决了问题(如果你不知道如何，只需创建一个新的文本文件并粘贴文本，它的工作原理相同，只要你不使用奇怪的德国字符，它应该是好的)。这其实是一个相当老的问题，已经存在了2年多，显然甲骨文并不关心它。
我发现了另一个"未记录的异常";对于这个问题。这真的很简单，只需将文件扩展名更改为".csv"(小写)。导入向导不喜欢"。csv";(大写).