Deprecated Final Support - ftString Parameter mapping to nText

[BenW]

Hi,

I'm currently using Delphi XE2 with dbexpsda40.dll 6.2.3.0

I have code that stores the contents of a file in an nvarchar(max) database column using an input param of type ftString.

When the file contains less than 4000 characters the generated query maps the file contents field to nvarchar(x) where x is the size of the chracter count in the file.

But when the file contains > 4000 characters (i.e. the limit for nvarchar(n)) the generated query maps the file contents field to nText.

nText currently raises a "Deprecation Final Support" message in SQL Server Profiler when you have Deprecation events enabled. I expect it should actually map to nvarchar(max) instead.

Has this been fixed in version 6.3.5?

Thanks

[PavloP]

Thank you for the information. We have reproduced this issue. We will investigate the possibility of changing this behaviour in the next dbExpress driver for SQL Server version.

[Dimon]

We have investigated the issue. This behavior is due to OLEDB provider, and not dbExpress driver.
Since OLEDB provider is used in DbxSda by default, then the parameter is mapped to nText. If you use NativeClient provider, the field will be mapped to nvarchar(max).
To use SQL Native Client provider, you should set the TSQLConnection.VendorLib property to 'sqlncli'.