Is it expected?
On Sun, Apr 11, 2010 at 11:54 AM, Tito Garrido <titogarr...@gmail.com>wrote:
> I could test it on Shell, not sure why it's happening:
>
> In[0]:
>
> p=db(db.paciente.id>0).select()[1].as_dict()
>
> Out[0]:
> In[1]:
>
> p
>
> Out[1]:
>
> *{'bairro': 'Gra\xc3\xa7a',* 'telefone_residencial': '', 'numero': '492',
> 'mae': '', 'celular': '', 'pai': '', 'data': '2009-10-20', 'id': 2,
> 'telefone_comercial': '', 'nome': 'Tito \xc3\xa1 \xc3\xa9', 'emissor':
> 'SSP-BA', 'cidade': 'Salvador', 'nascimento': '2009-10-20', 'rg': '09376709',
> 'endereco': 'Rua 8', 'estado': 'Bahia', 'email': 'te...@teste.com'}
>
> In[2]:
>
> p=db(db.paciente.id>0).select().json()
>
> Out[2]:
> In[3]:
>
> p
>
> Out[3]:
>
> '[{"telefone_comercial": null, "data": "2009-10-20", "bairro": "",
> "nascimento": "2009-10-20", "emissor": "", "cidade": "", "nome": "Tito
> Garrido Ogando", "telefone_residencial": null, "numero": "", "email": null,
> "rg": "", "mae": "", "celular": null, "endereco": "", "pai": "", "estado":
> "", "id": 1}, {"telefone_comercial": "", "data": "2009-10-20", *"bairro":
> "Gra\\u00e7a"*, "nascimento": "2009-10-20", "emissor": "SS", "cidade":
> "Salvador", "nome": "Tito \\u00e1 \\u00e9", "telefone_residencial": "",
> "numero": "492", "email": "te...@teste.com", "rg": "0709", "mae": "",
> "celular": "", "endereco": "Rua 8", "pai": "", "estado": "Bahia", "id": 2},
> {"telefone_comercial": null, "data": "2009-10-20", "bairro": "",
> "nascimento": "2009-10-20", "emissor": "", "cidade": "", "nome": "Garrido
> Tito", "telefone_residencial": null, "numero": "", "email": null, "rg": "",
> "mae": "", "celular": null, "endereco": "", "pai": "", "estado": "", "id":
> 3}, {"telefone_comercial": null, "data": "2010-03-01", "bairro": "",
> "nascimento": null, "emissor": "", "cidade": "", "nome": "",
> "telefone_residencial": null, "numero": "", "email": null, "rg": "", "mae":
> "", "celular": null, "endereco": "", "pai": "", "estado": "", "id": 4},
> {"telefone_comercial": null, "data": "2010-03-02", "bairro": "G",
> "nascimento": null, "emissor": "SSP-BA", "cidade": "S", "nome": "Titoooo",
> "telefone_residencial": null, "numero": "", "email": null, "rg": "09379",
> "mae": "", "celular": null, "endereco": "R", "pai": "", "estado": "B", "id":
> 5}]'
>
>
>
> I've increased the font of a UTF-8 entry (it's should be "Graça")
>
>
>
>
> On Sun, Apr 11, 2010 at 11:47 AM, Tito Garrido <titogarr...@gmail.com>wrote:
>
>> In fact looks like it loses the UTF-8 enconding when I print it or convert
>> it to string...
>>
>> Is there a way to re encode it?
>>
>> Regards,
>>
>> tito
>>
>>
>> On Sun, Apr 11, 2010 at 11:35 AM, mdipierro <mdipie...@cs.depaul.edu>wrote:
>>
>>> 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).:_______
>>>
>>
>>
>>
>> --
>>
>> Linux User #387870
>> .........____
>> .... _/_õ|__|
>> ..º[ .-.___.-._| . . . .
>> .__( o)__( o).:_______
>>
>
>
>
> --
>
> Linux User #387870
> .........____
> .... _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:_______
>
--
Linux User #387870
.........____
.... _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:_______
