Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here

Thai characters are not showing up correctly

Alteryx
Alteryx
Created

Environment Details


Issue

The Thai characters are showing up as garbled characters in the Browse tool.


Summary

Importing Thai data from Oracle Database using Oracle ODBC driver is displaying the Thai characters as garbled characters in Alteryx. This can be addressed by setting a parameter in the driver to unconditionally change the data type to support Unicode.


Environment

  • Oracle ODBC Driver


Cause


The ODBC driver is unable to read in the Unicode characters. 

Resolution


Perform the following steps to address this issue:

1. In Windows, open up ODBC Data Source Administrator (64 bit).
2. Look for the DSN that you have created for Oracle database connection.
3. Open the DSN and go to "Workarounds" tab.
4. Check the "Force SQL_WCHAR Support".
 

idea Skyscrapers

Setting the "Force SQL_WCHAR Support"option enables the Unicode support.


Additional Resources