Unicode issue in IDoc to JDBC scenario

[Former Member]

Hi,

I am facing unicode issue in IDoc to JDBC scenario, SAP is sending some cyrillic characters(non english), in PI they are coming fine but getting converted to ? in JDBC table.

Can anyone please help me with the solution, I am not sure where I can handle encoding in receiver JDBC channel!

Thanks

navneet.

[former_member183816]

By default PI uses UTF-8 encoding. and cyrillic characters should gets coonverted using this encoding.

That means your JDBC system is using different encoding than UTF-8, I guess.

You can use following two beans to convert it into correct encoding,

Adding TextCodepageConversionBean in the Module Processor -  Adding Modules to the Module Processor...

Inserting MessageTransformBean in Module Processor -  Adding Modules to the Module Processor - SAP ...

Following screen is just an example how to use them in channel, It's not necessary that it will solve your issue.

[neilpadilla]

Hi Navneet,

Make sure that your database can handle the Cyrillic characters.

You can check the following link on how the the characters are handled in the database.

https://confluence.atlassian.com/display/DOC/Configuring+Database+Character+Encoding

Regards,

Neil