Skip to Content
0
Apr 23, 2007 at 07:46 AM

Unicode JDBC Receiver Adapter

89 Views

Hi All,

My reciever system is <b>MS SQL</b> (version > 7.0). when i send unicode data through XI, the query in the runtime workbench does show the unicode values. but they are getting inserted as <b>??????</b>. if i copy the same query into the <b>SQL Analyzer</b> and prefix the unicode content with '<b>N</b>', it is getting inserted into SQL as Unicode charecters. i tried to prefix the content of the fields in the mapping. but when i did that, the charecter N is appended to the content of the field. the collation of the SQL server is <b>SQL_Latin1_General_CP1_CI_AS</b>. can any one help in this regard? it is bothering from long time.

Thnx in advance