UnicodeEncodeError: 'latin-1' codec can't encode character 解决sae flask 中文问题

#encoding=utf-8
#中文编码支持 import MySQLdb
from flask import Flask, g, request app = Flask(__name__)
app.debug = True from sae.const import (MYSQL_HOST, MYSQL_HOST_S,
MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB
) @app.before_request
def before_request():
g.db = MySQLdb.connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS,
MYSQL_DB, port=int(MYSQL_PORT))
#g.db.set_character_set('utf8')
g.db.set_character_set('utf8') 这句话加上去就OK了。

以下是网上的方案原帖。
 

"UnicodeEncodeError:'latin-1' codec can't encode character ..."

This is because MySQLdb normally tries to encode everythin to latin-1. This can be fixed by executing the following commands right after you've etablished the connection:

db.set_character_set('utf8')
dbc.execute('SET NAMES utf8;') dbc.execute('SET CHARACTER SET utf8;')
dbc.execute('SET character_set_connection=utf8;')

"db" is the result of MySQLdb.connect, and "dbc" is the result of db.cursor().

意思就是MySQLdb正常情况下会尝试将所有的内容转为latin1字符集处理

 
所以处理方法就是,设置连接和游标的charset为你所希望的编码,如utf8

db是connection连接,dbc是数据库游标

http://*.com/questions/3942888/unicodeencodeerror-latin-1-codec-cant-encode-character

上一篇:贪心 Codeforces Round #301 (Div. 2) B. School Marks


下一篇:hdu 4700 那个啥树