Can I get SQLite for a string instead of unicode for TEXT in Python?

Question

AFAIK SQLite returns unicode objects for TEXTin Python. Is it possible to get SQLite to return string objects?

Answer 1

While further testing the Python SQLite API, I found this a bit:

http://docs.python.org/library/sqlite3.html#sqlite3.Connection.text_factory

Case is closed.

Answer 2

TEXTDesigned to store text. Use BLOBif you want to save bytes.

Answer 3

Python 3.2+. unicode ( Python 2.7)