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

Reply via email to