something wrong about the encode

[董少洋]

When I visit the page /roles/list/, I get the error like this:

Traceback (most recent call last):
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/app.py", line 1988, in wsgi_app
    response = self.full_dispatch_request()
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/app.py", line 1641, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/app.py", line 1544, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/app.py", line 1639, in full_dispatch_request
    rv = self.dispatch_request()
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/app.py", line 1625, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/security/decorators.py", line 26, in wraps
    return f(self, *args, **kwargs)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/views.py", line 453, in list
    widgets=widgets)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/baseviews.py", line 158, in render_template
    return render_template(template, **dict(list(kwargs.items()) + list(self.extra_args.items())))
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/templating.py", line 134, in render_template
    context, ctx.app)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask/templating.py", line 116, in _render
    rv = template.render(context)
  File "/home/work/.jumbo/lib/python2.7/site-packages/jinja2/environment.py", line 989, in render
    return self.environment.handle_exception(exc_info, True)
  File "/home/work/.jumbo/lib/python2.7/site-packages/jinja2/environment.py", line 754, in handle_exception
    reraise(exc_type, exc_value, tb)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 2, in top-level template code
    {% import 'appbuilder/general/lib.html' as lib %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/base.html", line 1, in top-level template code
    {% extends base_template %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/caravel/templates/caravel/base.html", line 1, in top-level template code
    {% extends "appbuilder/baselayout.html" %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/caravel/templates/appbuilder/baselayout.html", line 2, in top-level template code
    {% import 'appbuilder/baselib.html' as baselib %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/init.html", line 46, in top-level template code
    {% block body %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/caravel/templates/appbuilder/baselayout.html", line 21, in block "body"
    {% block content %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 7, in block "content"
    {% block list_search scoped %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 8, in block "list_search"
    {% call lib.accordion_tag("accordion1",_("Search"), False) %}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/general/lib.html", line 254, in template
    {{ caller() }}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/templates/appbuilder/general/model/list.html", line 9, in template
    {{ widgets.get('search')()|safe }}
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/widgets.py", line 108, in __call__
    form_fields[col] = self.template_args['form'][col]()
  File "/home/work/.jumbo/lib/python2.7/site-packages/wtforms/fields/core.py", line 153, in __call__
    return self.meta.render_field(self, kwargs)
  File "/home/work/.jumbo/lib/python2.7/site-packages/wtforms/meta.py", line 56, in render_field
    return field.widget(field, **render_kw)
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/fieldwidgets.py", line 174, in __call__
    return super(Select2ManyWidget, self).__call__(field, **kwargs)
  File "/home/work/.jumbo/lib/python2.7/site-packages/wtforms/widgets/core.py", line 288, in __call__
    html.append(self.render_option(val, label, selected))
  File "/home/work/.jumbo/lib/python2.7/site-packages/wtforms/widgets/core.py", line 301, in render_option
    return HTMLString('<option %s>%s</option>' % (html_params(**options), escape(text_type(label), quote=False)))
  File "/home/work/.jumbo/lib/python2.7/site-packages/flask_appbuilder/security/sqla/models.py", line 45, in __repr__
    permission_id = Column(Integer, ForeignKey('ab_permission.id'))
UnicodeEncodeError: 'ascii' codec can't encode characters in position 6-9: ordinal not in range(128)

To solve the problem,I add
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
in the front of models.py
But it seems nothing to help.Can anyone tell me where the problem is?

[Haytham Amin]

I am having the same problem with Mysql

[Maxime Beauchemin]

One thing that seems to help with MySQL is to add the `?charset=utf8` suffix to you SQLAlchemy connection string.

I also would recommend using Python3 if you are having unicode issues, but at Airbnb we run Python2.7 and we don't see these errors.

Max