Wrong Encoding for JDBC-Receiver

[Former Member]

Dear all,

we've to convert from UTF-8 to ISO-8859-1 before we write payload data into database. We've tried with "AF_Modules/XMLAnonymizerBean" but it does not work!

Is there any issue regarding JDBC? Should we use "AF_Modules/TextCodepageConversionBean" instead?

Kind regards, Stefan

[Former Member]

Solved, custom adapter was the problem

[prateek]

TextCodepageConversionBean only works for text messages. Which database version are you using? What change in character are you facing?

Regards,

Prateek

[Former Member]

We're using oracle 9.2 and we've to put in german "Umlaute" like "ä", "ü" and "ö".

Kind regards, Stefan

[shweta_walaskar2]

Hello Stefan,

Did you try MessageTransformBean?

Regards,

Shweta

[Former Member]

Hello Shweta,

not for changing the encoding. We are using it for Plain2XML, e.g. reading flat files from MQ-Series.

Which parameters do we have to specify for changing the encoding?

Kind regards, Stefan

[shweta_walaskar2]

Hi Stefan,

Sorry for the delay in response:

Please use the following parameters:

Module Name Type Module Key

localejbs/AF_Modules/MessageTransformBean Local Plain2XML

Module Key Parameter Name Parameter Value

Plain2XML Transform.ContentType text/xml;charset=utf-8

Also,if this doesn't work ,please try charset=iso-8859-1 as well.

Let us know if it helps.

Thanks.

Regards,

Shweta

[Former Member]

Hi Stefen,

Pls try with SQL statment convert function

select SEGMENT1,convert(DESCRIPTION, 'UTF8', 'WE8ISO8859P1') as DESCRIPTION from <XXXtablename>

Hope it will work to reslove the issue.

Thanks,

venkat