Alteryx Designer Desktop Knowledge Base
Definitive answers from Designer Desktop experts.Alteryx doesn't read some unicode characters correctly
Issue
When reading a field with some non-western characters the Result Window doesn't show the same characters that we get when we run the same query from the Input tool in a data query tool directly in the database outside of Alteryx. Example:
1. Query Result from data query tool:
2. Designer - Result Window:
Environment
Diagnosis
Oracle
Characters are all Unicode.
Cause
This happens because we translate varchar2 to a V_String in Alteryx and the Unicode data gets lost.
Solution
Add a TO_NCHAR in the query to convert the field. If you change it after it's already been read in, the data has already been lost.
Correct Results:
When reading a field with some non-western characters the Result Window doesn't show the same characters that we get when we run the same query from the Input tool in a data query tool directly in the database outside of Alteryx. Example:
1. Query Result from data query tool:
2. Designer - Result Window:
Environment
- Alteryx Designer
- Version 2020.2
Diagnosis
Oracle
Characters are all Unicode.
Cause
This happens because we translate varchar2 to a V_String in Alteryx and the Unicode data gets lost.
Solution
Add a TO_NCHAR in the query to convert the field. If you change it after it's already been read in, the data has already been lost.
Correct Results:
