Massimo the mentioned issue has been fixed in pydal. Have you found other different issues?
Paolo On Sunday, June 21, 2015 at 6:14:29 PM UTC+2, Massimo Di Pierro wrote: > > I think we should remove pg8000 unless this unicode problem is fixed. It > just causes problem to new pgsql users. psycopg2 is solid. > > On Thursday, 18 June 2015 12:59:44 UTC-5, Paolo Valleri wrote: >> >> In general the best choice is psycopg2 however, the issue with pg8000 has >> been fixed >> I've written an initial basic unittest >> https://github.com/web2py/pydal/blob/master/tests/base.py#L72 to check >> possible issues with unicode >> >> >> Paolo >> >> 2015-06-18 19:47 GMT+02:00 Antonio Salazar <asala...@gmail.com >> <javascript:>>: >> >>> Is it still recommended to use psycopg2 instead of pg8000 after this fix? >>> >>> El lunes, 15 de junio de 2015, 5:28:09 (UTC-5), Paolo Valleri escribió: >>> >>>> According to my tests, the current PG adapter works only with psycopg2 >>>> and python2.7 >>>> It is broken with both pg8000 and psycopg2 on python 3.x >>>> >>>> A possible fix for pg8000 and python2.7 is here >>>> https://github.com/ilvalle/pydal/commit/d5450938ae606a3e85deffa831899a35146f5e64 >>>> >>>> I've posted an issue for psycopg2 with python3.x here >>>> https://github.com/psycopg/psycopg2/issues/331#issuecomment-111909256 >>>> >>>> Paolo >>>> >>>> On Saturday, June 13, 2015 at 5:22:07 AM UTC+2, Massimo Di Pierro wrote: >>>>> >>>>> It is a bug in pg8000. You need to install psycopg2 >>>>> >>>>> On Friday, 12 June 2015 13:51:55 UTC-5, Antonio Salazar wrote: >>>>>> >>>>>> I have the same problem. PostgreSQL database, web2py >>>>>> 2.11.2-stable+timestamp.2015.05.30.16.33.24 >>>>>> source install. >>>>>> >>>>>> Now any field update which has non-ASCII characters fails with "<type >>>>>> 'exceptions.UnicodeDecodeError'> 'ascii' codec can't decode byte 0xc3 in >>>>>> position X: ordinal not in range(128)" >>>>>> By any field update, I mean custom forms, form grids, and even >>>>>> database administration. >>>>>> >>>>>> This is the traceback after failing to change a user's name to "José" >>>>>> with database administration: >>>>>> >>>>>> Traceback (most recent call last): >>>>>> File "S:\Extranet\Website\Fuentes\web2py\gluon\restricted.py", line >>>>>> 227, in restricted >>>>>> exec ccode in environment >>>>>> File >>>>>> "S:/Extranet/Website/Fuentes/web2py/applications/extranet/controllers/appadmin.py" >>>>>> <http://127.0.0.1:8000/admin/edit/extranet/controllers/appadmin.py>, >>>>>> line 704, in <module> >>>>>> File "S:\Extranet\Website\Fuentes\web2py\gluon\globals.py", line 412, >>>>>> in <lambda> >>>>>> self._caller = lambda f: f() >>>>>> File >>>>>> "S:/Extranet/Website/Fuentes/web2py/applications/extranet/controllers/appadmin.py" >>>>>> <http://127.0.0.1:8000/admin/edit/extranet/controllers/appadmin.py>, >>>>>> line 343, in update >>>>>> if form.accepts(request.vars, session): >>>>>> File "S:\Extranet\Website\Fuentes\web2py\gluon\sqlhtml.py", line 1686, >>>>>> in accepts >>>>>> self.id_field_name]).update(**fields) >>>>>> File >>>>>> "S:\Extranet\Website\Fuentes\web2py\gluon\packages\dal\pydal\objects.py", >>>>>> line 2020, in update >>>>>> ret = db._adapter.update("%s" % table._tablename,self.query,fields) >>>>>> File >>>>>> "S:\Extranet\Website\Fuentes\web2py\gluon\packages\dal\pydal\adapters\base.py", >>>>>> line 996, in update >>>>>> raise e >>>>>> UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 57: >>>>>> ordinal not in range(128) >>>>>> >>>>>> >>>>>> I don't recall having this problem with pre 2.10 versions >>>>>> >>>>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/web2py/AE6NVmLPCwk/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+un...@googlegroups.com <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.