From a27cc907a55ed7172fda97f7db2732ea54ba7dae Mon Sep 17 00:00:00 2001 From: Rick Morrison Date: Tue, 8 Apr 2008 19:09:33 +0000 Subject: Add a new 'odbc_autotranslate' engine/dburi kwd parm to the MSSQL pyodbc dialect; string kwd contents will be passed through to ODBC connection string. [ticket:1005] --- lib/sqlalchemy/databases/mssql.py | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index e0bf2e6bb..6cc5f4fd3 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -792,7 +792,14 @@ class MSSQLDialect_pyodbc(MSSQLDialect): connectors.append("UID=%s" % user) connectors.append("PWD=%s" % keys.get("password", "")) else: - connectors.append ("TrustedConnection=Yes") + connectors.append("TrustedConnection=Yes") + + # if set to 'Yes', the ODBC layer will try to automagically convert + # textual data from your database encoding to your client encoding + # This should obviously be set to 'No' if you query a cp1253 encoded + # database from a latin1 client... + if 'odbc_autotranslate' in keys: + connectors.append("AutoTranslate=%s" % keys.pop("odbc_autotranslate")) return [[";".join (connectors)], {}] def is_disconnect(self, e): -- cgit v1.2.1