SQL performance by setting sendStringParametersAsUnicode =false in .NET

Question

We migrated from Net Weaver to Tomcat for JAVA servers and during migration the sendStringParametersAsUnicode parameter was not set as false in SQL connection URL which causes severe performance degradation.

Now we are setting sendStringParametersAsUnicode=false explicitly for Java.

My question is, do we need to set this parameter while connecting to SQL 2008 from .NET 4?

As far as I know it is applicable for Java drivers/engine.

Below article explains more on sendStringParametersAsUnicode connection parameter.

the article

Ali HAMDI · Accepted Answer · 2013-11-15 15:03:14Z

2

This parameter is needed just for JAVA Drivers and is needed just when connecting with a Java application.

answered Nov 15, 2013 at 15:03

Ali HAMDI

4052 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL performance by setting sendStringParametersAsUnicode =false in .NET

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related