After upgrading from dbexpsda40.dll v6.3.5.0 to dbexpsda40.dll v7.1.3.0 the dataset field.size property behaviour has changed when pointing at a nvarchar column.
When connecting to a nvarchar(5) column with v6.3.5.0 of the dll the field.size is reported as 5 but when connecting with v7.1.3.0 of the dll the field.size is reported as 10.
Is this behaviour expected?
I'm connecting using the following parameters
Code: Select all
Connection.DriverName := 'DevartSQLServer';
Connection.Params.Values['HostName'] := EdServer.Text;
Connection.Params.Values['DataBase'] := EdDatabase.Text;
Connection.Params.Values['LibraryName'] := 'dbexpsda40.dll';
Connection.Params.Values['VendorLib'] := 'sqlncli';
Connection.Params.Values['GetDriverFunc'] := 'getSQLDriverSQLServer';
Connection.Params.Values['BlobSize'] := '-1';
Connection.Params.Values['LongStrings'] := 'True';
Connection.Params.Values['EnableBCD'] := 'False';
Connection.Params.Values['FetchAll'] := 'True';
Connection.Params.Values['TrimFixedChar'] := 'True';
Connection.Params.Values['ParamPrefix'] := 'True';
Connection.Params.Values['OS Authentication'] := 'True';
Connection.Params.Values['UseUnicode'] := 'True';
Thanks.