Python insert UTF8 string into SQLite

Question

I know there are similar questions, but the answers are distinct and kind of confusing.

I have this string:

titulo = "Así Habló Zaratustra (Cómic)"

When I try to insert it to the SQLite database I get the error:

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.

I've tried a couple of things without success. Please help.

Martijn Pieters · Accepted Answer · 2014-09-27 22:24:25Z

9

Do what it tells you to do and use unicode values instead:

titulo_unicode = titulo.decode('utf8')

The sqlite3 library will take care of encoding this correctly when inserting, decoding again when selecting.

edited Sep 27, 2014 at 22:24

answered Sep 27, 2014 at 22:17

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

2 Comments

Mark Ransom Feb 1 at 15:24

Hopefully this is no longer a problem unless you're using ancient Python 2.x.

Martijn Pieters Apr 4 at 13:19

@MarkRansom: well, back in September 2014 Python 2.7 was the norm; Python 3.5 was only just out but most Python shops stuck to 2.x still. The tide was just about to turn by this point, however. I've added the python-2.x tag to the question to make it clear what context this should be read in.

Collectives™ on Stack Overflow

Python insert UTF8 string into SQLite

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related