[Sqlalchemy-tickets] [sqlalchemy] #2076: Unicode-related error when using sqlite with str containing non-ascii characters

[sqlalchemy <mi...@zz...>]

#2076: Unicode-related error when using sqlite with str containing non-ascii
characters
--------------------+-------------------------------------------------------
 Reporter:  guest   |          Owner:  zzzeek              
     Type:  defect  |         Status:  new                 
 Priority:  medium  |      Milestone:  0.6.xx              
Component:  sqlite  |       Severity:  minor - half an hour
 Keywords:          |   Status_field:  awaiting triage     
--------------------+-------------------------------------------------------
 See attached testcase (testcase.py) and output (output.txt). 'In the
 wild,' this error occurs when trying to INSERT the content of a binary
 file into a Text column. In the testcase, this is simulated using a str
 object that is populated with a unicode escape.

 Original code looked somewhat like this:

 strval = ""
 with open("somepdf.pdf") as f:
   strval = f.read()

 In other words, strval is filled with binary data from a file.

 When executed:
 - using sqlite url: first commit succeeds, second fails
 - using mysql url: both commits succeed as expected

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2076>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python