Starting with Teradata Database 16.0, Unicode pass-through stores, retrieves, and analyzes emojis and other ideographs.
- Set the startup string for the user who will be connecting to the Teradata system:
- In the Administration perspective, double-click Databases.
- In Object List Viewer, right-click the user and select Open Database/User.
- In the General tab, make sure Startup String reads: set session character set unicode pass through on;
- Add the RUNSTARTUP JDBC property for the connection:
- In the Navigtor, right-click the connection profile and select Properties
- Click the Teradata JDBC Connection Properties tab.
- Enter the credentials for the user and Vantage system you are connecting to:
- Click Add next to JDBC Connection Properties.
- In the Add JDBC Property dialog, select the RUNSTARTUP JDBC property, select the property value ON, and click OK.
- Click OK to close the Properties dialog.
- Set the font that supports displaying symbols such as emojis:
- Select .
- Select Text Font, and click Edit.
- In the Font dialog, select the Segoe UI Symbol font and click OK.
- Click OK to close the Preferences dialog.