[PACTH] Add a new argument handling for the mssql engine on odbc: autotranslate

Issue #1005 resolved
Former user created an issue

This patch adds the possibility to autotranslate=No as an argument on the dburi:

exemple:

dburi = "mssql://user:pass@localhost/testdb?autotranslate=No"

this will enable users to override the default settings (at least on windows) that force the translation of textual data. This way a french windows host will be able to connect to a greek database (with a collation name set to cp1253) and the ODBC layer will not try to translate the textual data.

The intended usage for those cases is to have a model that uses TEXT for the column and then pass convert_unicode=True and encoding="%s" % yourencodinghere on the create_engine() call...

We have worked together with Jerôme Collette and me (Florent Aide) on this patch and this works with live production data from a cp1253 encoded database (Greek) from French Windows XP machines using MDAC 2.8.1

Best regards, Florent.

Comments (4)

  1. Log in to comment