FIX: Some parameter values that are sent in a non-Unicode format may be incorrectly converted when you use the SQL Server 2000 Driver for JDBC (910369)

MORE INFORMATION

Code to reproduce the problem

import java.sql.*;

/*Run the following commands in SQL Query Analyzer before you try the code sample.*/ 
/*use Northwind
GO
create table texttable( text varchar(20))
GO */ 

public class Params
{
	static Connection con;

	public static void main(String[] args) throws SQLException
	{
		try
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 

			Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind;SendStringParametersAsUnicode=false;selectmethod=direct","uid","pwd");


			String text = "abcd\u20ac\u201a\u0192\u201e";

			System.out.println("Inserting:");
			for (int i=0; i<text.length(); i++)
			{
				int ivalue = text.charAt(i);
				String output =  Integer.toHexString( (int) ivalue) ;
				System.out.print(output + " ");
			}
			System.out.println();	
			
			PreparedStatement pstmt = null;
			String sqlQuery = "delete from texttable;insert into texttable (text) values (?)";

			pstmt = con.prepareStatement(sqlQuery);
			pstmt.setString(1, text);
			pstmt.execute();

			pstmt.close();
			pstmt=null;

			Statement st = con.createStatement();
			ResultSet rs=st.executeQuery("Select text from texttable");
			System.out.println("Obtained:");
			while (rs.next())
			{
				String s = rs.getString(1);
				for (int i=0; i<s.length(); i++)
				{
					int ivalue = s.charAt(i);
					String output =   Integer.toHexString( (int) ivalue) ;
					System.out.print(output + " ");
				}
				System.out.println();
			}

			con.close();
			con=null;
		}
		catch(Exception e)
		{
			System.out.println(e);
			e.printStackTrace();
		}
	}
}

Output before fix

Output after fix