Re: MS SQL Server, JDBC, and Unicode?

Tom Anderson wrote:


I can't get it not to work.

:-)

The following is tested with the MS driver (driver for 2000
against 2000, but I expect 2005 against 2005 to work identical):

public class Unicode {
   public static void main(String[] args) throws Exception {
       Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); // SQLServer 2000
       Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost;DatabaseName=Test", "sa", "");
       Statement stmt = con.createStatement();
       stmt.executeUpdate("CREATE TABLE unifun (id INTEGER NOT NULL, data NVARCHAR(50), PRIMARY KEY(id))");
       stmt.executeUpdate("INSERT INTO unifun VALUES(1,N'?????? the wrong way')");
       PreparedStatement pstmt = con.prepareStatement("INSERT INTO unifun VALUES(?,?)");
       pstmt.setInt(1, 2);
       pstmt.setString(2, "?????? the correct way");
       pstmt.executeUpdate();
       ResultSet rs = stmt.executeQuery("SELECT id,data FROM unifun");
       while(rs.next()) {
           System.out.println(rs.getInt(1) + " : " + rs.getString(2));
       }
       rs.close();
       stmt.executeUpdate("DROP TABLE unifun");
       stmt.close();
       con.close();
   }
}