I installed psycopg2 and all work fine now. Thanks anyway Massimo
El dom., 22 sep. 2019 03:48, Massimo Di Pierro <[email protected]> escribió: > ... and can you show us the complete traceback? > > On Saturday, 21 September 2019 23:47:28 UTC-7, Massimo Di Pierro wrote: >> >> Can you try? >> >> nombre_cliente = u'SECRETARÍA' >> >> What is your connection string? which python version? >> >> On Saturday, 21 September 2019 23:43:42 UTC-7, Luciano Fain wrote: >>> >>> Dear Team >>> >>> I have a string with an special charater on it: 'SECRETARÍA XXX' >>> >>> When i try to do an insert on DB >>> >>> id_encabezado = db.encabezado.insert(tipo_reg = 0,nombre_cliente = >>> 'SECRETARÍA' ) >>> >>> got the following error: >>> >>> <faultstring>'ascii' codec can't decode byte 0xc3 in position 942: >>> ordinal not in range(128)</faultstring> >>> >>> I have tried: >>> >>> nombre_cliente = unicode ('SECRETARÍA') >>> >>> nombre_cliente = ('SECRETARÍA').encode('utf-8) >>> >>> and nothing seems to work >>> >> -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/4e6457db-20f5-422c-9bc0-02a53f5ce689%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/4e6457db-20f5-422c-9bc0-02a53f5ce689%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CANSBBCkEVt%2Bva_nKydkz6-WMmh4RHG5MYYQwKTr3qe6P2pWhyA%40mail.gmail.com.
