XPost: comp.lang.java.programmer   
   From: dcest61@hotmail.com   
      
   Tom Anderson wrote:   
   > On Fri, 10 Jul 2009, Arne Vajh?j wrote:   
   >   
   >> Tom Anderson wrote:   
   >>> Has anyone made SQL Server work with unicode in java?   
   >>   
   >> 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://local   
   ost;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();   
   >>    }   
   >> }   
   >   
   > Silly question, but those ?s were unicode characters before you pasted   
   > this into usenet, right?   
   [ SNIP ]   
      
   FWIW, Tom, I saw his original characters OK when I read his post...just   
   a bunch of unlauts that he'd need when he reads and writes in his   
   heathen language... :-)   
      
   AHS   
      
   * I'm one to talk - if I read and write in my mother tongue I need äöüõ.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)