Subject: Pysqlite, APSW and unicode version

Hi,

I've written a script[1] that reads in CSV files, inserts the tables 
into a database and fetches the records afterwards. The CSV files are 
UTF-8 encoded (but they also could be any other encoding).

With psysqlite this all works fine while with APSW I have to decode 
the UTF-8 byte strings before I can insert them into the database via 
"executemany". So obviously pysqlite does the decoding transparently 
(which probably is not good as the byte strings could have any 
encoding).

How does does pysqlite know which encoding to use for byte strings for 
execute (or executemany) statements?


Thorsten
[1] http://thorstenkampe.de/computing/python/sql.py/document_view