python - Flask-SQLAlchemy插入中文到MySQL时出现问题?

 洛熙难耐_467 发布于 2022-10-30 12:29
from app import db,User
user=User(username='我')
db.session.add(user)
print(user.username)

此时输出正常

当我

db.session.commit()

之后出现了错误

c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\default.py:450: Warning: Incorrect string value: '\xD6\xD0\xB9\xFA\xB1\xEA...' for column 'VARIABLE_VALUE' at row 475
  cursor.execute(statement, parameters)
Traceback (most recent call last):
  File "", line 1, in 
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\scoping.py", line 150, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\session.py", line 813, in commit
    self.transaction.commit()
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\session.py", line 392, in commit
    self._prepare_impl()
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\session.py", line 372, in _prepare_impl
    self.session.flush()
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2027, in flush
    self._flush(objects)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2145, in _flush
    transaction.rollback(_capture_exception=True)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\session.py", line 2109, in _flush
    flush_context.execute()
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 373, in execute
    rec.execute(self)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 532, in execute
    uow
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\persistence.py", line 174, in save_obj
    mapper, table, insert)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\orm\persistence.py", line 785, in _emit_insert_statements
    execute(statement, params)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\sql\elements.py", line 323, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1010, in _execute_clauseelement
    compiled_sql, distilled_params
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1146, in _execute_context
    context)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1341, in _handle_dbapi_exception
    exc_info
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\util\compat.py", line 200, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1139, in _execute_context
    context)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\sqlalchemy\engine\default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\MySQLdb\cursors.py", line 226, in execute
    self.errorhandler(self, exc, value)
  File "c:\Users\Sanch\Desktop\Reborn\venv\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
    raise errorvalue
sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1366, "Incorrect string value: '\\xCE\\xD4\\xB2\\xDB' for column 'username' at row 1") [SQL: u'INSERT INTO users (email, username, password, role_id) VALUES (%s, %s, %s, %s)'] [parameters: (None, '\xce\xd4\xb2\xdb', None, 2)]

MySQL中相应列的编码格式是UTF-8,在MySQL中直接插入中文没有问题:

2 个回答
  • 你的python默认是gbk

    2022-10-31 21:30 回答
  • 这种场景要用 unicode 类型:

    user=User(username=u'我')
    2022-10-31 21:30 回答
撰写答案
今天,你开发时遇到什么问题呢?
立即提问
热门标签
PHP1.CN | 中国最专业的PHP中文社区 | PNG素材下载 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有