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.