community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Thai characters are not showing up correctly

clarab
Alteryx
Alteryx
Created

‎07-14-2020 02:53 AM

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

Labels