Enabling Teradata Unicode Pass-Through - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Starting with Teradata Database 16.0, Unicode pass-through stores, retrieves, and analyzes emojis and other ideographs.
  1. Set the startup string for the user who will be connecting to the Teradata system:
    1. In the Administration perspective, double-click Databases.
    2. In Object List Viewer, right-click the user and select Open Database/User.
    3. In the General tab, make sure Startup String reads: set session character set unicode pass through on;
  2. Add the RUNSTARTUP JDBC property for the connection:
    1. In the Navigtor, right-click the connection profile and select Properties
    2. Click the Teradata JDBC Connection Properties tab.
    3. Enter the credentials for the user and Vantage system you are connecting to:
      1. Click Add next to JDBC Connection Properties.
      2. In the Add JDBC Property dialog, select the RUNSTARTUP JDBC property, select the property value ON, and click OK.
      3. Click OK to close the Properties dialog.
  3. Set the font that supports displaying symbols such as emojis:
    1. Select Window > Preferences > General > Appearance > Colors and Fonts.
    2. Select Text Font, and click Edit.
    3. In the Font dialog, select the Segoe UI Symbol font and click OK.
    4. Click OK to close the Preferences dialog.