Re: Subject: Pysqlite, APSW and unicode version

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Gerhard Häring wrote:
> SQLite strings are per definitionem UTF-8 encoded. There are no checks by
> SQLite or pysqlite wether the bytestrings you use are actually UTF-8
> encoded, but if they're not, chances are you'll get problems later on.

Note that APSW explicitly checks strings supplied from Python and
generates an error if they are not pure ASCII.  That ensures that you
have to correctly encode them, and that only correctly Unicode encoded
strings end up in SQLite databases which means you'll only get valid
Unicode strings back out.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG40gcmOOfHg372QQRAu4YAKDQOHdPIYdDfP2zGWhFEcJ6eMl47wCg4Zi3
UmVLYpuYRzF9G+FbnKC8rgo=
=UBGJ
-----END PGP SIGNATURE-----