[转] Python错误记录：' pymysql KeyError:255'

最新推荐文章于 2021-01-30 05:29:40 发布

wccms

最新推荐文章于 2021-01-30 05:29:40 发布

阅读量169

点赞数

分类专栏： python

原文链接：https://blog.csdn.net/feng_jlin/article/details/82758946

版权

python 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Traceback (most recent call last): ... File "C:\Program Files\Python36\lib\site-packages\pymysql\__init__.py", line 90, in Connect return Connection(*args, **kwargs) File "C:\Program Files\Python36\lib\site-packages\pymysql\connections.py", line 706, in __init__ self.connect() File "C:\Program Files\Python36\lib\site-packages\pymysql\connections.py", line 931, in connect self._get_server_information() File "C:\Program Files\Python36\lib\site-packages\pymysql\connections.py", line 1269, in _get_server_information self.server_charset = charset_by_id(lang).name File "C:\Program Files\Python36\lib\site-packages\pymysql\charset.py", line 38, in by_id return self._by_id[id] KeyError: 255

主要原因是MySQL8.0更新了很多字符集，但是这些字符集长度超过255了，所以旧版的PyMySQL不支持长度超过255的字符
解决方法，更新PyMySQL：

pip install --upgrade PyMySQL