SqlAlchemy未使用utf8字符集即使已指定
我在用Flask和Flask-SqlAlchemy搭配MySQL，而我的连接字符串里确实有charset-utf8这个参数。
我还在使用反射，我的模型是这样定义的：
class Value(db.Model):
__bind_key__ = 'values'
__tablename__ = 'values'
我也试过在我的文件里加上# -*- coding:utf8 -*-这行代码，但我还是遇到了这些错误信息：
Traceback (most recent call last):
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1403, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask_debugtoolbar/__init__.py", line 125, in dispatch_request
return view_func(**req.view_args)
File "/usr/lib/python2.7/cProfile.py", line 149, in runcall
return func(*args, **kw)
File "/home/numkem/src/sd/application/views/player.py", line 54, in player_show
return render_template('player/show.html', **locals())
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/templating.py", line 128, in render_template
context, ctx.app)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/flask/templating.py", line 110, in _render
rv = template.render(context)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/jinja2/environment.py", line 969, in render
return self.environment.handle_exception(exc_info, True)
File "/home/numkem/src/sd/venv/lib/python2.7/site-packages/jinja2/environment.py", line 742, in handle_exception
reraise(exc_type, exc_value, tb)
File "/home/numkem/src/sd/application/templates/player/show.html", line 1, in top-level template code
{% extends "base.html" %}
File "/home/numkem/src/sd/application/templates/base.html", line 62, in top-level template code
{% block body %}{% endblock %}
File "/home/numkem/src/sd/application/templates/player/show.html", line 27, in block "body"
<td>{{ field.values }}</td>
UnicodeEncodeError: 'ascii' codec can't encode character u'\xe1' in position 16: ordinal not in range(128)
为什么连接时会忽略字符集设置？难道不应该由连接字符串来决定吗？也许在使用反射的时候，这个设置根本就不支持。
谢谢！
2 个回答
0
这个错误的意思是，你在模板中传递了非Unicode字符串作为上下文，因为Jinja2只支持Unicode格式的字符串。
你应该看看这篇关于编码的资料。
4
其实问题并不是出在SqlAlchemy上，而是Jinja2本身没有识别到我想在整个应用中使用utf8编码。文档上说，如果没有特别指定，默认编码是ascii。
这个回答提供了我问题的解决方案。
解决办法是把这个加到你的第一段代码里：
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
我对python不是特别熟悉，但我猜这可能和使用WSGI应用有关，而不是普通的脚本，所以# -*- coding:utf8 -*-这个方法就不管用了。