=== modified file 'modules/db.mssql/db_mssql_grt.py' --- modules/db.mssql/db_mssql_grt.py 2014-02-24 11:55:25 +0000 +++ modules/db.mssql/db_mssql_grt.py 2014-03-04 16:29:00 +0000 @@ -644,6 +644,12 @@ if datatype is not None: column.simpleType = mssql_rdbms_instance.simpleDatatypes[datatype] + # When information about the columns are retrieved from sys.columns (server version is 9 or greater) - + # field CHARACTER_MAXIMUM_LENGTH return length in bytes, so length in characters for type NCHAR and NVARCHAR + # sholud be divided by two. + if serverVersion.majorNumber >= 9 and column.simpleType is not None and column.simpleType.name in ['NCHAR', 'NVARCHAR']: + column.length = column.length/2 + default_value = row_values['COLUMN_DEFAULT'] if default_value is not None: