Enabling Teradata Unicode Pass-Through | Teradata Studio/Studio Express - Enabling Teradata Unicode Pass-Through - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
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.