Re: sqlite3.OperationalError: Could not decode to UTF-8 column

2007-09-06 Thread Filipe Sousa
Carsten Haese wrote: > On Wed, 2007-09-05 at 16:40 +0100, Filipe Sousa wrote: > > Try setting > > conn.text_factory = str > > where conn is the name of your sqlite3 connection object. See > http://docs.python.org/lib/sqlite3-Connection-Objects.html for more > information. > > HTH, > Thanks! I

Re: sqlite3.OperationalError: Could not decode to UTF-8 column

2007-09-05 Thread Carsten Haese
e from aluno') > sqlite3.OperationalError: Could not decode to UTF-8 column 'nome' with > text 'Ana Margarida Fernandes Gonçalves de Sá' > > The database was created with another program and all data is in > database is in latin1. Try setting conn.text_

sqlite3.OperationalError: Could not decode to UTF-8 column

2007-09-05 Thread Filipe Sousa
Hi I'm trying to use sqlite with python 2.5 but I have this problem: Traceback (most recent call last): File "converter.py", line 13, in c_old.execute('select id_aluno, nome from aluno') sqlite3.OperationalError: Could not decode to UTF-8 column 'n