Unicode in JDBC sender

[Shabarish_Nair]

Hi All,

We are having issues with special characters in the JDBC sender adapter.

I went through the SAP note and on the unicode this is what it says;

Unicode Handling

Q: I am inserting Unicode data into a database table or selecting Unicode data from a table. However, the data inserted into or retrieved from the table appears garbled. Why doesn't the JDBC Adapter handle Unicode correctly?

A: While the JDBC Adapter is Unicode-aware, many JDBC drivers and/or database management systems aren't by default and need a codepage or Unicode-awareness to be configured explicitly. For the respective JDBC drivers, this codepage setting is often configured via the driver URL. For details, refer to the documentation of your JDBC driver or database management system.

Note: For the Lotus Domino Driver for JDBC, there does not seem to be any documented method to enable support for Unicode strings.

We are using a Oracle DB. How do we achieve this?(this codepage setting is often configured via the driver URL)

Is this something to be done in the adapter configuration or is it at a driver level during the deployment?

Appreciate inputs!!!

Thanks,

Shabz

[prateek]

In the Connection field of ur JDBC sender communication channel, use parameter sendStringAsUnicode=true.

e.g. jdbc:sqlserver://hostname:1433;databaseName=DBDev;sendStringParametersAsUnicode =true

Regards,

Prateek