http://blogs.msdn.com/b/sqlcat/archive/2010/04/05/character-data-type-conversion-when-using-sql-server-jdbc-drivers.aspxAuthor: Kun Cheng Reviewers: Wanda He, Kevin Cox, Michael Thomassy, Peter Scharlock In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It starteden-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlcat/archive/2010/04/05/character-data-type-conversion-when-using-sql-server-jdbc-drivers.aspx#10050473Mon, 16 Aug 2010 11:27:34 GMT91d46819-8472-40ad-a661-2c78acb4018c:10050473Aslam Khatri<p>This article helps me resolving an issue of performance degradation due to index not being applied as a results of uni-code conversion by sql server driver. Thanks</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10050473" width="1" height="1">http://blogs.msdn.com/b/sqlcat/archive/2010/04/05/character-data-type-conversion-when-using-sql-server-jdbc-drivers.aspx#9991818Wed, 07 Apr 2010 16:01:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:9991818Brian Tkatch<p>Very interesting! We don't seem to have this issue, but we are using the same setup. </p> <p>Thanx for sharing. This may be very useful one day.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9991818" width="1" height="1">