XPost: comp.lang.java.programmer   
   From: twic@urchin.earth.li   
      
   On Sat, 11 Jul 2009, Arne Vajh?j wrote:   
      
   > 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.   
   >>   
   >> Thanks for doing this, Arne - i should probably have tried it myself. It   
   >> eliminates one area of doubt about the problem, but still leaves me none   
   >> the wiser as to why the system won't do unicode right. Maybe it's   
   >> constructing SQL strings internally, rather than using PreparedStatements,   
   >> and not using the N'?' syntax. I really don't think that's the case, though   
   >> - i've seen evidence from debugging and stack traces that   
   >> PreparedStatements are indeed used.   
   >   
   > We will need more info to trouble shoot.   
   >   
   > code   
   > what is being inserted   
   > what is being selected out   
      
   All of that is under the hood where i can't really get at it, sadly.   
      
   Although i could trap the queries and the results with the SQL Server   
   profiler.   
      
   And i could run the app under a debugger and breakpoint all the   
   interesting methods, to see what's actually being called.   
      
   If i can find time to work on this (full unicode support is not a high   
   priority right now), and if i get an answer, i'll post my findings here,   
   in case anyone's interested.   
      
   tom   
      
   --   
   The final chapter, prophetic, poetic   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)