home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 17,556 of 19,505   
   =?ISO-8859-1?Q?Arne_Vajh=F8j?= to Dan Guzman   
   Re: MS SQL Server, JDBC, and Unicode?   
   11 Jul 09 14:02:51   
   
   XPost: comp.lang.java.programmer   
   From: arne@vajhoej.dk   
      
   Dan Guzman wrote:   
   >> 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.   
   >   
   > I want to second Erland's suggestion to capture the actual SQL with   
   > Profiler.  Also, check the JDBC sendStringParametersAsUnicode setting to   
   > make sure it is set to true.   
      
   I would be worth trying.   
      
   Arne   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca