I can get it as UTF-8 if I execute:
test=db(db.mytable.id>0).select()[0].as_dict()
return test
Not sure why it's not encoding on the former situation.
How could I convert it manually?
Thanks!
On Sun, Apr 11, 2010 at 2:15 AM, mdipierro <mdipie...@cs.depaul.edu> wrote:
> I am not sure the issue is web2py here. It may be 1) the encoding in
> the db should be utf8 and it is not, 2) the data has been stored
> incorrecly. web2py does not convert data to UTF8 when extracting from
> DB but when inserting only.
>
> On Apr 10, 11:17 pm, Tito Garrido <titogarr...@gmail.com> wrote:
> > Hi Folks,
> >
> > I'm not sure why but when I'm using as_dict function in a row element
> it's
> > not returning UTF-8 characters an example:
> >
> > db.define_table('evento',
> > SQLField('dono','reference auth_user',writable=False,readable=False),
> > SQLField('paciente', 'reference paciente', label='Paciente*'),
> > SQLField('titulo', 'string', length=255
> ,default='',label='Assunto*'),
> > SQLField('data','date',default=request.now,readable=False),
> > SQLField('horario','time',readable=False),
> > SQLField('duracao','integer'),
> > SQLField('status', 'string', length=255 ,default='Marcado'),
> > SQLField('comentario', 'text',default=''),
> > SQLField('criado_por','reference
> > auth_user',writable=False,readable=False))
> >
> > eventos=db((db.evento.data.day()==data.day)&
> > (db.evento.data.month()==data.month)&
> > (db.evento.data.year()==data.year)&
> > (db.evento.dono==dono_id)).select(orderby=db.evento.horario)
> >
> > for evento in eventos:
> > *eventos_as_list.append(evento.as_dict())*
> > #some other operations
> >
> > return eventos_as_list
> >
> > Those elements inside this list "eventos_as_list" are not encoded as
> utf-8,
> > it shows something like:
> > *{'status': 'Marcado', 'paciente': 1, 'id': 11, 'horario': '08:00:00',
> > 'criado_por': 2, 'dono': 2, 'titulo': 'Criado pelo modal', 'data':
> > '2010-03-20', 'comentario': 'Descri\xc3\xa7ao \xc3\xa1
> \xc3\xa9\r\n\r\ncom
> > mais uma linha\r\n\r\natt'}*
> >
> > Not sure if it's happening because I'm appending it to a list... is there
> a
> > way to solve it?
> >
> > Regards,
> >
> > Tito
> >
> > --
> >
> > Linux User #387870
> > .........____
> > .... _/_õ|__|
> > ..º[ .-.___.-._| . . . .
> > .__( o)__( o).:_______
>
>
> --
> To unsubscribe, reply using "remove me" as the subject.
>
--
Linux User #387870
.........____
.... _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:_______
