Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Oracle SQL file ( UTF-8 ) Into StreamCommand not returning correct character set
Labels:
- Labels:
-
Apache NiFi
New Contributor
Created 11-10-2022 10:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
