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 !!
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.