Skip to Content
avatar image
Former Member

Unicode problem in JDBC receiver adapter

Dear All,

We are having a JDBC-JDBC scenario . Our application data contains Korean

characters which are shown properly in Moni.

But when we go to the receiver database table the Korean characters in the respective feilds are replaced by '????'

This is very urgent.

Points will be awarded

Regards

Sunil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 25, 2007 at 01:48 PM

    Check if your JDBC drivers request UTF-16.

    In this case change the encoding of the XMl to UTF-16 with help of the XMLAnonymizerBean.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sunil,

      Check this out , this worked for me......

      In the XML sent to the channel you will have to use a special quoting

      for any Unicode strings, which the JDBC Adapter will not produce on its

      own. Instead, you need to add an attribute 'hasQuot="no"' to those

      elements (most likely in the mapping where you produce the XML) and

      explicitly enclose the data in single quotes prefixed with the letter N.

      For clarity, one example:

      If your original "INSERT" operation looks like this:

      <StatementName2>

      <dbTableName action="INSERT">

      <table>realDbTableName</table>

      <access>

      <col1>val1</col1>

      <col2>val2</col2>

      </access>

      </dbTableName>

      </StatementName2>

      and "col1" contains Unicode data, change the document as follows:

      <StatementName2>

      <dbTableName action="INSERT">

      <table>realDbTableName</table>

      <access>

      <col1 hasQuot="no">N'val1'</col1>

      <col2>val2</col2>

      </access>

      </dbTableName>

      </StatementName2>

      Thanks

      Shankar

  • avatar image
    Former Member
    Oct 19, 2007 at 02:16 PM

    is your database nls enabled..?

    Regards

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2007 at 02:32 PM

    u are seeing the entires of database using TOAD client??

    Thanks

    Farooq.

    Add comment
    10|10000 characters needed characters exceeded