Japanese, Chinese characters from Oracle are broken with Input data

[Azureslake]

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 solution]

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-...

Best,

Fernando Vizcaino

[Azureslake · Accepted solution]

Thanks! fmvizcaino!

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

Now i can see it.

[NitinBhagat]

Hello, I do not see a solution here, how to read Japanese characters via odbc connection.

My problem statement is as under. 

Workflow results are not getting properly encoded with Japanese character’s in Server Alteryx designer. It works fine when same workflow is run in user's local Alteryx designer.

Screenshot of user’s Alteryx designer:

Screenshot of Server Alteryx designer:

[NitinBhagat]

In the Advance Options, while creating the ODBC Data Source pleaset tick the highlighted option.