UTF-8 Encoding while pulling data from Oracle DB using OCI connection string

[singh28ashish]

Hi All,

While fetching data to Alteryx from oracle DB. I want to convert data convert in UTF-8 encoding. I tried also ConvertFromCodepage but it didn't work. Please help here. Below is sample data.

Col A which I fetched from oracle DB due to conversion issue its converted in ? col b is output and ? converted to –

Col A	Col b
10kW Rack 48u (AR2587 APC 48u 800mm wide 1200 deep) ? 2 No 3phase 32A supplies at LHC	10kW Rack 48u (AR2587 APC 48u 800mm wide 1200 deep) – 2 No 3phase 32A supplies at LHC

Thanks,

Ashish

[cjaneczko]

Do you have the following box checked in your OCI connection manager?

[singh28ashish]

@cjaneczko : No I am directly using connection string like below attached screenshot as well

oci:SVC_IHUBTIBS/@@@$123@10.152.03.55:1521/SVWSIT1Z

Thanks

[cjaneczko · Accepted solution]

In the input tool for your database connection enable that checkbox. If you've created the connection via the Database Connections you can do it on that screen. If you dont have the DCM setup then you can do it via the Input tool configuration in the below area. This should preserve the character formatting and not change it to another character on import.