- > 4.10 AND TrimVarChar

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 26
Joined: Wed 04 Oct 2006 01:41 - > 4.10 AND TrimVarChar

Post by oodesigns » Sun 16 Sep 2007 10:05


I am now moving now latest server to production and found it did not work. This issue was TrimVarChar. The last server in production was built using 3.55.017 and we are moving to 4.10. I found (after many hours) that TrimVarChar had to be set true in 4.10. Why did 3.55 which did not have this setting work. Was it always trimmed before?

Now having set to true will this have a large impack in performance. I.e should I stick with 3.55.


Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 17 Sep 2007 12:27

Before implementing this option in SDAC, (N)VARCHAR values were not trimmed. Enabling this option should have no significant influence on performance.

Post Reply