MySQLdb

[Skip Montanaro]

    Lukas> I want add the new record to Mysql database. When I use my script
    Lukas> I got an exception "UnicodeEncodeError: 'ascii' codec can't
    Lukas> encode character u'\xe4' in position 12: ordinal not in
    Lukas> range(128).

Lukas,

You will need to encode your Unicode objects before stuffing the resulting
strings into MySQL.  For example:

    utf8foo = foo.encode("utf-8")
    c.execute("insert into blah blah blah", (..., utf8foo, ...))

instead of 

    c.execute("insert into blah blah blah", (..., foo, ...))

Skip