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 [email protected].
For more options, visit https://groups.google.com/d/optout.
