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

[JoshHP]

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

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.

 

Additional Resources

 

• How to Connect to an Oracle Database in Alteryx