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.

NIfi executesql / querydatabasetable on an oracle database not returning correct Unicode (Arabic ) characters

Highlighted

NIfi executesql / querydatabasetable on an oracle database not returning correct Unicode (Arabic ) characters

New Contributor

it's returning something like " H2'1) 'D-13 'DH7FJ "

oracle database info:

NLS_CHARACTERSET AL32UTF8

NLS_RDBMS_VERSION 12.2.0.1.0

i am using oracle ojdbc8.jar driver and I tried ojdbc6.jar and orai18n.jar the driver should be able to handle AL32UTF8 Unicode characters and Nifi jvm should do the conversion internally and return correct Unicode data , but it’s not .

On nifi server I have java version "1.8.0_101"

Nifi version 1.4.0

Appreciate any help

Don't have an account?
Coming from Hortonworks? Activate your account here