From e75ec97c2b74741f273cac55b90f227d00e35d93 Mon Sep 17 00:00:00 2001 From: Paul Johnston Date: Mon, 3 Sep 2007 13:57:08 +0000 Subject: [PATCH] Minor fixes to MSSQL reflection --- lib/sqlalchemy/databases/mssql.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lib/sqlalchemy/databases/mssql.py b/lib/sqlalchemy/databases/mssql.py index 5f07ac2965..3e8949e14f 100644 --- a/lib/sqlalchemy/databases/mssql.py +++ b/lib/sqlalchemy/databases/mssql.py @@ -580,8 +580,8 @@ class MSSQLDialect(default.DefaultDialect): warnings.warn(RuntimeWarning("Did not recognize type '%s' of column '%s'" % (type, name))) coltype = sqltypes.NULLTYPE - elif coltype == MSNVarchar and charlen == -1: - charlen = None + elif coltype in (MSNVarchar, AdoMSNVarchar) and charlen == -1: + args[0] = None coltype = coltype(*args) colargs= [] if default is not None: @@ -593,7 +593,7 @@ class MSSQLDialect(default.DefaultDialect): raise exceptions.NoSuchTableError(table.name) # We also run an sp_columns to check for identity columns: - cursor = connection.execute("sp_columns " + self.identifier_preparer.format_table(table)) + cursor = connection.execute("sp_columns [%s]" % self.identifier_preparer.format_table(table)) ic = None while True: row = cursor.fetchone() -- 2.47.3