Support Questions

Find answers, ask questions, and share your expertise

Oracle SQL file ( UTF-8 ) Into StreamCommand not returning correct character set

avatar
New Contributor

Using the ExecuteStreamCommand processor, I am trying to execute a SQL file which has multibyte characters included in the file.

 

Sample SQL command :

 

select 'Lávañya' from dual;

 

 

The expected output should be the exact same characters. When running the file directly with the sqlcl client via command line , the output works as expected. However, when processed through the ExecuteStreamCommand processor the output results:

Lávañya

 

I have set nifi to use the UTF8 encoding:

java.arg.8=-Dfile.encoding=UTF8

 

I have tried setting the encoding directly into the sql file, and this doesn't change the output.

 

Running Windows Server 2019

NiFi 1.14.0

 

Thanks in advance, any help is appreciated.

 

 

0 REPLIES 0