hmmm, please try
bd[tab].insert(nome=u'testé')
or
bd[tab].insert(nome='testé'.encode('utf8'))
On Jun 7, 9:49 am, Felipe <felip...@gmail.com> wrote:
> Hi,
>
> I'm having problems with UTF8 words and databases...
>
> Now I'm using postgres with web2py. I used a xml-rpc script, just for
> testing, to insert into a table the word 'testé', apparently
> everything worked well, but when I try to get the info from the table
> I receive an error, 'cant decode unicode byte ... something', so i
> went to the postgres comand line and did
>
> select * from table;
>
> and i got a testÚ in the table...
>
> the database is using correct utf8, i know that web2py is also all
> utf8 and the xml-rpc also used utf8
>
> here it is come source code
>
> id = bd[tab].insert(nome='testé')
> try:
> bd.commit()
> retorno = 1
> except:
> retorno = 0
> return retorno
