Hello, To cut a long explanation, I have the following:
MS-SQLServer <-> FreeTDS <-> unixODBC <-> pyODBC <-> DAL The database is in Latin1 The FreeTDS configuration adds client charset = UTF-8 Before putting "charset = UTF-8" had throughout the application encodes and decodes to make it work well, but after putting it magically everything works fine. At some point, I think when we update the web server (hardware and software versions), it began to malfunction with non-ASCII characters. Specifically today I have: - All readings to database work fine, the characters show good - This fails: sql = "INSERT INTO T_UTF8 (name) values ('Ñandú')" db.executesql(sql) Result: Ã?andú - This work fine: sql = *u*"INSERT INTO T_UTF8 (name) values ('Ñandú')" db.executesql(sql) Result: Ñandú - This fails: tb_t_utf8.insert(name='Ñandú') Result: Ã?andú - And if inserted from a form also fails [*] With that fails I mean that inserts the record but with rare characters. [**] All html files are in utf8 Best Regards Jose -- 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.