Skip to main content
ep_gunner
Silver ⭐️
February 19, 2021
Solved

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

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 ?

TimothySpann
Platinum ⭐️⭐️⭐️
February 22, 2021

that depends on default session that Oracle JDBC driver settings.

 

it's usually utf-8 though

1 reply

TimothySpann
Platinum ⭐️⭐️⭐️
Platinum ⭐️⭐️⭐️
February 22, 2021

that depends on default session that Oracle JDBC driver settings.

 

it's usually utf-8 though

Translate