Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Oracle - Special character "≥" returns incorrectly as "="

JoshHP
Alteryx
Alteryx
Created

Issue:

 

When using special charater "≥" value in a database Input Data tool, the field displays as "=".
 

Example:

In an Oracle Database tool, the value of the field display as:

≥20% range

In Desinger Data Input tool, the value displays as:

=20% range

 

Environment Details

  • Alteryx Designer
    • All
  • Oracle
    • All
    • Database character set is AL32UTF8


Cause

 

Unicode character is corrupted. String/V_String formats only accept Latin-1 characters, and ≥ is not a Latin-1 character. 



Resolution

 
  1. Go to the ODBC Data Source Administrator configuration
image.png
  1. Depending on how you set up your DSN, select either the User DSN or System DSN tab.
  2. Select your existing Oracle Data Source and click Configure.
  3. NOTE: If you do not have an existing Oracle Data Source, please review the article "How to Connect to an Oracle Database in Alteryx " to set one up.
  4. In the Oracle ODBC Configuration window, select the Workarounds tab and check "Force SQL_WCHAR Support". This checkbox enables Unicode support, so Unicode characters are extracted and transferred into Alteryx as a WString or V_WString instead of as a String/V_String.
image.png
 
 


Additional Resources

 
No ratings