On Tue, 17 Jun 2008 09:23:28 +0200, Peter Otten <[EMAIL PROTECTED]> wrote: > Assuming that encoding is UTF-8 and that apsw can cope > with unicode, try to convert your data to unicode before > feeding it to the database api: > >> sql = "INSERT INTO mytable (col1,col2) VALUES (?,?)" > > rows = ([col.decode("utf-8") for col in row] for row in >records("test.tsv")) > cursor.executemany(sql, rows)
Thanks again. -- http://mail.python.org/mailman/listinfo/python-list