KNOWLEDGE BASE

Special characters are not displayed when connected to Teradata


Published: 14 Jun 2021
Last Modified Date: 15 Jun 2021

Issue

Special characters are not displayed when connected to Teradata. Example: € 

Environment

  • Tableau Desktop

Resolution

Add the following content to a TDC file with a Charset of UTF16:

<connection-customization class='teradata' enabled='true' version='9.0'>
    <vendor name='teradata' />
    <driver name='teradata' />
    <customizations>
        <customization name='odbc-connect-string-extras' value='Charset=UTF16' />
    </customizations>
</connection-customization>


Cause

Charset for Teradata is ASCII by default and such special characters are with Unicode Character set
Did this article resolve the issue?