How to set useUnicode=yes& characterEncoding=UTF-8 in DBCPConnectionPool for Oracle in NIFI?

Question

I am using DBCPConnectionPool in order to create a connection and extract data from Oracle DB. But data results were extracted with wrong font. I guess it's due to not set UTF-8 in connection string.

I found a example when set DBCPConnectionPool for MySQL with utf-8: Database Connection URL is set as below:

jdbc:mysql://localhost:3306/?useUnicode=yes&characterEncoding=UTF-8.

But I am not sure how does look like for Oracle. Could you please help me give any solution? Thanks.

did you see the answer here: https://stackoverflow.com/a/6047081 — hotfix, Jul 02 '19 at 07:11
https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-url-format.html — daggett, Jul 02 '19 at 10:19
question seems about mysql database and not about oracle. right? — daggett, Jul 02 '19 at 10:23
No. I am asking about oracle. I can find this case for MySql but cannot find for oracle. So I need a support. — Dung Tran Thi Thuy, Jul 02 '19 at 11:01
All db drivers has different properties. For Oracle no such parameters. https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html — daggett, Jul 02 '19 at 11:08
So you know how to set encoding=utf-8 in DBCPConnectionPool for Oracle in NIFI? — Dung Tran Thi Thuy, Jul 02 '19 at 12:15

score 0 · Accepted Answer · answered Jul 02 '19 at 16:22

0

This page might be helpful to understand the intricacies of Unicode support in Oracle. To convert ASCII to UTF-8 in NiFi, use the ConvertCharacterSet processor.

answered Jul 02 '19 at 16:22

Andy

13,916
1
36
78

Thx :) I solved this issue without any changes in Nifi. Originally results of ExecuteSQL processor in Nifi are default with UTF-8. But due to something is wrong from my internal side, so I opened content in result with wrong font :( – Dung Tran Thi Thuy Jul 03 '19 at 10:22

How to set useUnicode=yes& characterEncoding=UTF-8 in DBCPConnectionPool for Oracle in NIFI?

1 Answers1