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

[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 <module>
     c_old.execute('select id_aluno, nome 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.

Thanks,
Filipe Sousa