Unrecognize Chinese Character

[shashank_shukla]

Hello,

SCENARIO:- 

I am working on one task in which I need to fetch the data from Oracle table and in the some of the columns there is a Chinese character available with the English character.

While fetching the character the English character is easily readable but for the Chinese character there is some unrecognize character is showing or the value is blank.

I need to store both the values in the database but on a Alteryx designer side I am getting the unrecognize character and blank values for Chinese character

Kindly help me out with this problem and if possible then send a sample workflow as well.

Thanks & Regards,

SHASHANK R. SHUKLA

[DataNath]

Hey @shashank_shukla, if you change the data type of the field to V_WString, does the issue persist? Perhaps the issue at the moment is that the data type is a more limiting one which only allows certain characters I.e. alphanumeric or Latin-1.

[DataNath]

(Or W_String), you can just add a select tool and change the field data type to achieve this.

[IraWatt]

Hey @shashank_shukla, I agree with @DataNath in the Alteryx docs Data Types | Alteryx Help only V_WString and WString data types are able to handle any Unicode characters. The VString will only handle Latin-1 characters.

[shashank_shukla]

Hello @IraWatt , @DataNath ,

I am still getting the same unrecognize character even after changing the Datatype for the column.

I have changed to both "W_String and "V_Wstring" datatype but still getting the same result.

[IraWatt]

@shashank_shukla are you connecting to the database directly with the input data tool or are you connecting to a file or using the IN'DB tools?

[shashank_shukla]

Hello @IraWatt ,

I have connect the Database with Input tool.

[IraWatt]

@shashank_shukla are the characters coming in as '?' or are they not appearing at all, can you take a screenshot? Looks like ODBC connections default to WVstring anyway so chinese characters should be passed fine into Alteryx:

[DataNath · Accepted solution]

There’s a great detailed post (linked below) on how to deal with this issue, even when inputting straight from a database. It contains a few options for possibly troubleshooting but let us know if none of these work:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-resolve-errors-in-Designer-f...

[shashank_shukla]

 Hello @DataNath and @IraWatt ,

Thank you very much for all of your help and support.
Now that the issue has been rectified on my end, I am receiving the correct data.
Thank you again, it means a lot. Have a wonderful day ahead of you.

Thanks And Regards,

SHASHANK R. SHUKLA