I use this same stack, and ran into encoding issues when updating the database, because of FreeTDS v.91.
But upgrading to FreeTDS v1.00.40 fixed all unicode issues: https://github.com/mkleehammer/pyodbc/issues/244 Connect with mssql4n, TDS_Version 7.1+, no need to set db_codec On Friday, 19 May 2017 02:07:27 UTC+1, Jose wrote: > > Hi J-Michel Angers > > Given: > pydal <-> pyodbc <-> UnixODBC <-> FreeTDS <-> MSSQL > > In freetds.conf I have: > > client charset = UTF-8 > > and in pydal I use mssql2 adapter, db_codec is not necessary > > 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.

