python mysqlデータベース'latin-1'codec can'tencode characterエラー問題解決
UnicodeEncodeError: 'latin-1' codec can't encode character
"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"is the result of MySQLdb.connect, and "dbc"is the result of db.cursor().
MySQLdbは通常、すべてのコンテンツをlatin 1文字セットに変換しようとします.
だから処理方法は、utf 8のような接続とカーソルのcharsetをあなたの望む符号化に設定することです.
dbはconnection接続、dbcはデータベースカーソル
http://stackoverflow.com/questions/3942888/unicodeencodeerror-latin-1-codec-cant-encode-character
"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は通常、すべてのコンテンツをlatin 1文字セットに変換しようとします.
だから処理方法は、utf 8のような接続とカーソルのcharsetをあなたの望む符号化に設定することです.
dbはconnection接続、dbcはデータベースカーソル
http://stackoverflow.com/questions/3942888/unicodeencodeerror-latin-1-codec-cant-encode-character