Input Tool - Special character "≥" returning as "="

[LisaD]

This is an Oracle database. 

In a database tool I can see the value of a field as

≥20% range

When I use the Input tool in Alteryx, the value displays as

=20% range

Any ideas on how to ensure I get the correct character value?

The database character set is AL32UTF8

Thank you in advance!

[Maskell_Rascal · Accepted solution]

Hi @LisaD 

Do you see a checkbox on your Input configuration labeled "Force SQL WChar Support"? If so, make sure it is checked. 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. This prevents the unicode characters from being corrupted. String/V_String formats only accept Latin-1 characters, and ≥ is not a Latin-1 character. 

You will probably want to update this character in your Alteryx workflow for further processing depending on what you need to do with the data. You can quickly convert this character using a formula tool and a replace function.

Hope that helps. 

Cheers!

Phil

[LisaD]

Thank you Thank you Phil!  I changed the ODBC settings (under Workarounds tab) to Force SQL_WCHAR Support and that corrected the issue.

-Lisa

[Maskell_Rascal]

@LisaD - Happy to help! 🙂

Please make sure to mark the response as solution so others can find it as well. 

Cheers!

Phil