Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unrecognize Chinese Character

shashank_shukla
8 - Asteroid

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

11 REPLIES 11
DataNath
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

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

IraWatt
17 - Castor
17 - Castor

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
8 - Asteroid

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
17 - Castor
17 - Castor

@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
8 - Asteroid

Hello @IraWatt ,

 

I have connect the Database with Input tool.

IraWatt
17 - Castor
17 - Castor

@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:

IraWatt_0-1654773360233.png

IraWatt_1-1654773374316.png

 

DataNath
17 - Castor
17 - Castor

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
8 - Asteroid

 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

Labels