Deprecated Final Support - ftString Parameter mapping to nText
Posted: Tue 25 Feb 2014 21:36
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
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