Error inserting (unicode?) text into sqlite3 database

Question

I have an sqlite3 database that I have created which I'm filling with data from a db2 database. I get an error when I run the following:

for row in db2_connection.execute(query):
    sqlite3_connection.execute("INSERT INTO MY_TABLE VALUES (?, ?, ?)", row)

Here's the error:

File "example.py", line 72, in load_micr_db
    sqlite3_connection.execute("INSERT INTO MY_TABLE VALUES (?, ?, ?)", row)
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a
text_factory that can interpret 8-bit bytestrings (like text_factory = str). 
It is highly recommended that you instead just switch your application to 
Unicode strings.

This sounds like excellent advice, but I don't know how to follow it. How do I "switch my application to Unicode strings"?

I'm using Python 2.6, pyodbc to query db2 9, sqlite3.

Ignacio Vazquez-Abrams · Accepted Answer · 2011-02-08 22:19:51Z

3

Use string literals prefixed with a u.

print u'I am a Unicode string.'

"Unicode in Python, Completely Demystified"

answered Feb 8, 2011 at 22:19

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

3 Comments

Steven Rumbalski Over a year ago

Can you unpack that? I switched my second line (from the above example to sqlite3_connection.execute(u"INSERT INTO MY_TABLE VALUES (?, ?, ?)", row) and still received the same error. Perhaps I misunderstood your answer?

Ignacio Vazquez-Abrams Over a year ago

The elements in row also need to be unicode if they're strings.

Steven Rumbalski Over a year ago

My db2 source was returning strings that needed to be decoded to unicode using 'latin-1'. Thanks for your help.

Collectives™ on Stack Overflow

Error inserting (unicode?) text into sqlite3 database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related