Insert non latin-1 to sql via python

Question

I have string somestr = '‘something’' and I want to insert it to sql via Python using MySQLdb

I am already using somestr.encode('latin-1', 'ignore') to get latin-1 from the text but it always give following error

UnicodeEncodeError: 'latin-1' codec can't encode character '\u2018'

Anyone know how to solve this issue?

Serge Kishiko · Accepted Answer · 2018-01-25 08:33:26Z

1

Try to set the charset when you create your database object like this:

db = MySQLdb.connect(host="localhost", user="root", passwd="", db ="foodb", use_unicode=True, charset="utf8")

answered Jan 25, 2018 at 8:33

Serge Kishiko

4861 gold badge6 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1