Procedure parametr with null character
Posted: Fri 26 Apr 2013 07:21
Hello
SQL Server permits for null character (ASCII 0) embedded in VARCHAR or NVARCHAR data. Also Delphi allows for #0 character in string.
However TMSStoredProc component incorectly passes such parameters to database if parameter type is NVARCHAR(any size) or VARCHAR(MAX). The value is trimmed on first null character. Procedures with VARCHAR parameter with size other than MAX work correctly.
I think there is problem in calculating size of data in bytes when procedure expect WideString parameter.
I use SDAC v.6.6.12, Delphi XE2 Update 4 HotFix 1 and SQL Server 2008 R2.
SQL Server permits for null character (ASCII 0) embedded in VARCHAR or NVARCHAR data. Also Delphi allows for #0 character in string.
However TMSStoredProc component incorectly passes such parameters to database if parameter type is NVARCHAR(any size) or VARCHAR(MAX). The value is trimmed on first null character. Procedures with VARCHAR parameter with size other than MAX work correctly.
I think there is problem in calculating size of data in bytes when procedure expect WideString parameter.
I use SDAC v.6.6.12, Delphi XE2 Update 4 HotFix 1 and SQL Server 2008 R2.