Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question