Teradata Database 16.0 supports Unicode pass-through. Unicode pass-through enables you to store, retrieve, and analyze emojis and other ideographs. You can utilize this feature by performing the following steps.
-
Set the startup string for the user who will be connecting to the Teradata system:
- In the Administration perspective, double-click Databases and select the user in the Object List Viewer.
- Right-click the row for the user and select Open Database/User. The property form for the user is displayed.
- In the General tab, ensure that the Startup String field reads: set session character set unicode pass through on; If it is not already set, modify the user properties to include the startup string.
-
Add the RUNSTARTUP JDBC property for the connection:
- In the Teradata JDBC Connection Properties step of the Connection Profile wizard, enter the credentials for the user and Teradata Database 16.0 system you are connecting to.
- Click the Add button next to JDBC Connection Properties.
- In the Add JDBC Property dialog, select the RUNSTARTUP JDBC property, select the property value ON, and click OK. The new property is listed in the JDBC Connection Properties display box.
-
Set the font that supports displaying symbols such as emojis:
- From the Window menu, select Preferences.
- Expand General > Appearance and click Colors and Fonts.
- Select Text Font, and click the Edit button.
- In the Font dialog, select the Segoe UI Symbol font and click OK.
- Click OK to close the Preferences dialog.