diff options
| author | Rick Morrison <rickmorrison@gmail.com> | 2008-04-08 19:09:33 +0000 |
|---|---|---|
| committer | Rick Morrison <rickmorrison@gmail.com> | 2008-04-08 19:09:33 +0000 |
| commit | a27cc907a55ed7172fda97f7db2732ea54ba7dae (patch) | |
| tree | 42ddd9367a2cb26ebab66036e31bd2d39d131aa5 /lib/sqlalchemy/databases/mssql.py | |
| parent | 86d088835a88c00af69090b6b7f1bae42ff5c09a (diff) | |
| download | sqlalchemy-a27cc907a55ed7172fda97f7db2732ea54ba7dae.tar.gz | |
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]
Diffstat (limited to 'lib/sqlalchemy/databases/mssql.py')
| -rw-r--r-- | lib/sqlalchemy/databases/mssql.py | 9 |
1 files changed, 8 insertions, 1 deletions
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): |