Here's how to reproduce:
>>> import web
>>> db = web.database(dbn='sqlite', db=':memory:')
>>> db.query("create table t(t text)")
0.0 (1): create table t(t text)
-1
>>> db.insert('t', t=u'\u20ac')
ERR: INSERT INTO t (t) VALUES (u'\u20ac')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.6/site-packages/web/db.py", line 701, in insert
self._db_execute(db_cursor, q1)
File "/usr/local/lib/python2.6/site-packages/web/db.py", line 530, in _db_execute
for x in sql_query.values()])
sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode strings.
using Python 2.6.2, web.py 0.31. My fix (simply remove line 951 from web/db.py):
--- db.py 2009-05-07 14:22:30.000000000 +0200
+++ db.py.orig 2009-05-07 14:21:25.000000000 +0200
@@ -948,6 +948,7 @@
"""
if val is True: return 1
elif val is False: return 0
+ elif isinstance(val, unicode): return val.encode(self.encoding)
else: return val
class FirebirdDB(DB):
Then:
>>> import web
>>> db = web.database(dbn='sqlite', db=':memory:')
>>> db.query("create table t(t text)")
0.0 (1): create table t(t text)
-1
>>> db.insert('t', t=u'\u20ac')
0.0 (2): INSERT INTO t (t) VALUES (u'\u20ac')
0.0 (3): SELECT last_insert_rowid();
1
Don't know if this is right, but I think it should be reported.
Which sqlite driver are you using? sqlite3 or pysqlite2?