When connecting to the TDV server using the TDV 8.3 HF 005 ODBC driver, the Japanese characters may get garbled. To deal with this issue a new property 'treatCharAsUnicode' has been added to the TDV 8.3 HF 005 driver.

All Supported Operating systems

To resolve the issue set the below property in the connection with the TDV server. This property can be passed in the connection URL or in the ODBC.INI file:

treatCharAsUnicode=true

The default value is set to 'false'. Some applications may need this to be set to 'True' for ASCII to be treated as Unicode characters.

NOTE: This works in Visual Studio 2012 32 or 64bit, and in MS Excel 2016 32 or 64bit. It DOES NOT work in lower versions of Excel than 2016 and when using MS QUERY for ODBC.
 

Japanese characters may get garbled when a connection is established with TIBCO Data Virtualization server using TDV 8.3 HF 005 ODBC driver.