flask mysql 中文_Flask-SQLAlchemy插入中文到MySQL时出现问题？

灰太狼 2023-01-11 13:23 176阅读 0赞

from app import db,User

user=User(username='我')

db.session.add(user)

print(user.username)

此时输出正常

![801e6b5e7e6407dbcc0ed5e5d00b9173.png][]

当我

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中直接插入中文没有问题：

![c8fdb1d8e06c29da62ef8ff7955b4aac.png][]

[801e6b5e7e6407dbcc0ed5e5d00b9173.png]: /images/20221119/91fcda80417c4b80a2e7c6f88f04810b.png
[c8fdb1d8e06c29da62ef8ff7955b4aac.png]: https://img-blog.csdnimg.cn/img_convert/c8fdb1d8e06c29da62ef8ff7955b4aac.png