[MSSQL] Fix string length when using nchar, nvarchar, ntext

qgis · Jul 5, 2017 · 8731840 · 8731840
1 parent 58878d0
commit 8731840
Showing 1 changed file with 6 additions and 1 deletion.
diff --git a/src/providers/mssql/qgsmssqlprovider.cpp b/src/providers/mssql/qgsmssqlprovider.cpp
@@ -410,11 +410,16 @@ void QgsMssqlProvider::loadFields()
         }
         if ( sqlType == QVariant::String )
         {
+          int length = query.value( 7 ).toInt();
+          if ( sqlTypeName.startsWith( "n" ) )
+          {
+            length = length / 2;
+          }
           mAttributeFields.append(
             QgsField(
               query.value( 3 ).toString(), sqlType,
               sqlTypeName,
-              query.value( 7 ).toInt() ) );
+              length ) );
         }
         else if ( sqlType == QVariant::Double )
         {