-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dinesh B Vadhia wrote: > Hi! I'm using pysqlite in Python 2.5.2 and got the following error [...] > sqlite3.OperationalError: Could not decode to UTF-8 column 'j' with text
You should use the pysqlite mailing list http://itsystementwicklung.de/pipermail/list-pysqlite/ The underlying cause is that either the text you provided was the str type and not valid UTF8 or that data being returned from the database was not a valid UTF8 string. Note that when using the SQLite C apis (UTF8 flavour), SQLite does not actually check that what is provided is valid UTF8. Consequently the data can be stored in the database and returned as is, which will then cause non-SQLite code trying to convert it from what is believed to be UTF8 to fail. You can use CAST as a workaround: http://apsw.googlecode.com/svn/publish/tips.html#unicode Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkpBbJUACgkQmOOfHg372QTUlgCeJjoZWb6ZjzB9MkFLZs9UXPbS 1LwAn2UE3s0X2MypWRExMYBWfoUcrEce =rkyA -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
