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

[#1]

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 ?

[#2 · Accepted solution]

that depends on default session that Oracle JDBC driver settings.

it's usually utf-8 though