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