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

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


python string sqlite unicode

On further inspection of the Python SQLite API, I found this little bit:

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

Case closed.

python string sqlite unicode

TEXT is intended to store text. Use BLOB if you want to store bytes.

python string sqlite unicode

Use Python 3.2+. It will automatically return string instead of unicode (as in Python 2.7)

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last