Are you tell me that
items=db(db.mytable.id>0).select(limitby=(0,1))
print items[0].as_dict()
for item in items: print item.as_dict()
produce two different outputs? It cannot be.
Massimo
On Apr 11, 9:00 am, Tito Garrido <titogarr...@gmail.com> wrote:
> 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).:_______
