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

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