Pythonmysql database & #39; latin

UnicodeEncodeError: latin-1codeccantencodecharacter... ThisisbecauseMySQLdbnormallytriestoencodeeverythintolatin-1.Thiscanbefixedbyexecutingthefollowingcommandsrightafteryouveetablishedtheconnection: db. s

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. s

"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 ().

This means that MySQLdb will normally convert all the content into the latin1 character set for processing.