Support Questions
Find answers, ask questions, and share your expertise

Character set when Nifi extract using ExecuteSQL from Oracle (ASCII/UTF-8/UTF-16....)

New Contributor

What is the default character set used within Nifi while extracting from Oracle using executeSQL ?

I have a use case of 2 database in 2 different character sets, was just curious, is there any way to identify the incoming character set & then over-ride it based on the target ?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Character set when Nifi extract using ExecuteSQL from Oracle (ASCII/UTF-8/UTF-16....)

Super Guru

that depends on default session that Oracle JDBC driver settings.

 

it's usually utf-8 though

View solution in original post

1 REPLY 1

Re: Character set when Nifi extract using ExecuteSQL from Oracle (ASCII/UTF-8/UTF-16....)

Super Guru

that depends on default session that Oracle JDBC driver settings.

 

it's usually utf-8 though

View solution in original post