Japanese, Chinese characters from Oracle are broken with Input data

Question

Hello!

I am just starting Alteryx Designer tool.

I am using ODBC to connect to Oracle database. if i get the data with 'Input data' from Oracle all Japanese and Chinese characters are displayed like '/£¿£¿£¿£¿£¿/'.

When I use PL/SQL too for this data no issue.('/ｼｮﾘﾅｼ/').

Tested

change dataset 'UTF-8'

change data type 'Wstring'

use ConvertToCodePage([Data], 20932)

But can't solve this issue.

I need your help to solve this issue.

Thank you.

fmvizcaino · Accepted Answer

Hi @Azureslake ,

Take a look at this tip below:

It was a comment by @CristonS in the topic: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Inputting-Data-in-Chinese-Japanese-and-Korean-Characters/ta-p/17333

Best,

Fernando Vizcaino

Azureslake · Accepted Answer

Thanks! fmvizcaino!

I used ODBC file format. so I can't see 'Force SQL Wchar support' option.

Now i can see it.