3.55.0.17 - > 4.10 AND TrimVarChar

oodesigns · Post by **oodesigns** » Sun 16 Sep 2007 10:05

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

Antaeus · Post by **Antaeus** » Mon 17 Sep 2007 12:27

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.