Convertion of Unicode to ASCII NIGHTMARE

[Roger Binns]

"Paul Boddie" <paul at boddie.org.uk> wrote in message news:1144081137.137744.253790 at i39g2000cwa.googlegroups.com...
> It looks like you may have Unicode objects that you're presenting to
> sqlite. In any case, with earlier versions of pysqlite that I've used,
> you need to connect with a special unicode_results parameter,

He is using apsw.  apsw correctly handles unicode.  In fact it won't
accept a str with bytes >127 as they will be an unknown encoding and
SQLite only uses Unicode internally.  It does have a blob type
using buffer for situations where binary data needs to be stored.
pysqlite's mishandling of Unicode is one of the things that drove
me to writing apsw in the first place.

Roger