XPost: comp.lang.java.programmer   
   From: twic@urchin.earth.li   
      
   Greets yalls,   
      
   Has anyone made SQL Server work with unicode in java?   
      
   I'm working on a system which wants to put unicode in a database. It does   
   this fine with Oracle, but we haven't been able to make it do so when the   
   database is SQL Server - and indeed the manufacturers of the system list   
   this as something that it won't do. Anything that isn't on the current   
   code page turns into a question mark.   
      
   Our columns are nvarchar, and sendStringParametersAsUnicode is true in the   
   JDBC URL. Is there more than this we need to do?   
      
   I've come across mention of a syntax which looks like N'this is a unicode   
   string' for writing unicode literals in SQL. Do i need to do that? How do   
   i do that if i'm using PreparedStatements?   
      
   We're using the MS driver. An alternative would be the open source jTDS -   
   any idea if that will fix the problem?   
      
   Thanks,   
   tom   
      
   --   
   Sometimes it takes a madman like Iggy Pop before you can SEE the logic   
   really working.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)