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
Solved! Go to Solution.
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.
(Or W_String), you can just add a select tool and change the field data type to achieve this.
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 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 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:
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: