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

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.