sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings

by

If you want to use 8-bit strings instead of unicode string in sqlite3, set appropriate text_factory for sqlite connection:

connection = sqlite3.connect(...)
connection.text_factory = str

More Related Contents:

  1. SQLite, python, unicode, and non-utf data
  2. What exactly do “u” and “r” string flags do, and what are raw string literals?
  3. How to remove \xa0 from string in Python?
  4. How to get string objects instead of Unicode from JSON?
  5. Why does Python print unicode characters when the default encoding is ASCII?
  6. Parameter substitution for a SQLite “IN” clause
  7. Get a list of all the encodings Python can encode to
  8. Non-ASCII characters in Matplotlib
  9. OperationalError: database is locked
  10. What is the difference between encode/decode?
  11. urllib2 read to Unicode
  12. ‘UCS-2’ codec can’t encode characters in position 1050-1050
  13. Sqlite3, OperationalError: unable to open database file
  14. Why doesn’t Python recognize my utf-8 encoded source file?
  15. How to read datetime back from sqlite as a datetime instead of string in Python?
  16. How to make Django slugify work properly with Unicode strings?
  17. Python 3: How to specify stdin encoding
  18. Python decompressing gzip chunk-by-chunk
  19. Identifier normalization: Why is the micro sign converted into the Greek letter mu?
  20. Passing a column name in a SELECT statement in Python
  21. Bulk insert huge data into SQLite using Python
  22. How do I treat an ASCII string as unicode and unescape the escaped characters in it in python?
  23. Python unicode regular expression matching failing with some unicode characters -bug or mistake?
  24. Is there a way to get a list of column names in sqlite?
  25. sqlite3.OperationalError: unable to open database file
  26. How do I get str.translate to work with Unicode strings?
  27. Convert “\x” escaped string into readable string in python
  28. How to encode Python 3 string using \u escape code?
  29. Convert JSON to SQLite in Python – How to map json keys to database columns properly?
  30. Python 3 chokes on CP-1252/ANSI reading

Leave a Comment