U
Ulrich Goebel
Hallo,
again: a python beginner problem... but I spent ours to solve it without
success.
I have an object (a variable) name, which gets its value from a
PostgreSQL database via a SELECT statement, an it sometimes has german
special characters as ß, ä, ö...
Then I would like to insert that value into a table in a SQLite
database. So I make a cursor cur on the table and prepare a SQL
statement like this:
sql = 'insert into tbl values(?)'
cur.execute(sql, (name,))
That ends up with the exception, for example,
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 6:
ordinal not in range(128)
The "position 6" is exactly the position of the special character, ß in
this case.
What to do?
Ulrich
again: a python beginner problem... but I spent ours to solve it without
success.
I have an object (a variable) name, which gets its value from a
PostgreSQL database via a SELECT statement, an it sometimes has german
special characters as ß, ä, ö...
Then I would like to insert that value into a table in a SQLite
database. So I make a cursor cur on the table and prepare a SQL
statement like this:
sql = 'insert into tbl values(?)'
cur.execute(sql, (name,))
That ends up with the exception, for example,
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 6:
ordinal not in range(128)
The "position 6" is exactly the position of the special character, ß in
this case.
What to do?
Ulrich