Page 1 of 1

3.55.0.17 - > 4.10 AND TrimVarChar

Posted: Sun 16 Sep 2007 10:05
by oodesigns
Hi

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.

Mike

Posted: Mon 17 Sep 2007 12:27
by Antaeus
Before implementing this option in SDAC 3.70.1.25, (N)VARCHAR values were not trimmed. Enabling this option should have no significant influence on performance.