Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

convertcharacterset not working

convertcharacterset not working

Contributor

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 REPLIES 2

Re: convertcharacterset not working

Contributor

Can anyone please help me with this issue?

Highlighted

Re: convertcharacterset not working

Contributor

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.