uni = 'Hey my name is Andr\xe9'
in_utf8 = uni.encode('utf-8')
some_string = in_utf8
decoded = some_string.decode('sjis')
using pyodbc on linux to insert unicode or utf-8 chars in a nvarchar mssql field