JDBC Channel Characterset

[Former Member]

Hello expert,

I have a question about JDBC channel.

the scenario is from ECC to Oracle DB. we need insert Chinese character into table. And the characterset on ECC system is Unicode, character set on Oracle DB is WE8ISO8859P1.

I find there is no field to set characterset in JDBC receive channel.

Is there anyway to do the characterset transfer? Any standard module could be used here?

any suggestion would be appreciated.

thanks a lot.

Regards,

Kevin Song

[Former Member · Accepted solution]

Hi all,

The question is closed. We solved this issue via creating a middle ware database which using the same character set with PI. and then transfer the encoding when reading data to 3rd party db system.

Until now there is not better way to do the encoding convention in PI.

Regards,

Kevin Song

[SeKumar · Accepted solution]

Solution : 1- Insert "hasQuot" attribute to your target Data_Type element. 2- Make hasQuot false using the value "No" in the Message_Mapping. 3- Concat the source value with the prefix "N'" and suffix "'" in the Message_Mapping

[former_member208934]

HI Kevin,

Try with below driver URL

use the extra code to end of the string ( ?useUnicode=true&characterEncoding=UTF-8 )

jdbc:mysql://localhost/unicode?useUnicode=true&characterEncoding=UTF-8

Regards,

Venkat.

[Former Member]

Hi Venkat,

Thanks for your reply. But I don't think that string could be used after Oracle driver.

I will recheck that.

[Former Member]

Hi Venkat,

Thanks for your reply. But I don't think that string could be used after Oracle driver.

I will recheck that.

[Former Member]

Hi Kevin,

You should check your JDBC driver.

Check the SAP note 831162 (FAQ: XI 3.0 / PI 7.0 JDBC Adapter) is pointed this question (2question). The codepage is configured in the driver.

Regards.

[Former Member]

Thank you Vila,

I will check it.

[SeKumar]

Solution :

1- Insert "hasQuot" attribute to your target Data_Type element.

2- Make hasQuot false using the value "No" in the Message_Mapping.

3- Concat the source value with the prefix "N'" and suffix "'" in the Message_Mapping.