convertcharacterset not working

[#1]

Hello All,

I am moving data from one Oracle database to another. My flow is like this:

ExecuteSQL -> SplitAvro -> ConvertRecord ( to generate SQL statement) -> ConvertCharacterSet ( UTF-8 to ISO-8859-1) -> PutSQL

Source oracle DB has character set AL32UTF8

Target oracle DB has character set WE8ISO8859P1

But I see lots of ?? in the target database. Any clues on what I am doing wrong here?

P.S : My flow runs slow as I am not using prepared statement. I will work on this once this character set issue is resolved.

Thanks in advance !!

[#2]

Can anyone please help me with this issue?

[#3]

What do you find in the source database where ?? appears in the target database ? Also while you are doing that plz look at the Hex values of the same characters in the source database as well so that you are not missing any non displayable characters.