Introduction to International Character Set Support | Teradata Vantage - 17.20 - Introduction to International Character Set Support - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.20
Published
June 2022
Last Update
2022-06-24
Content Type
Configuration
User Guide
Publication ID
B035-1125-172K
Language
English (United States)

Teradata Vantage™ is our flagship analytic platform offering, which evolved from our industry-leading Teradata® Database. Until references in content are updated to reflect this change, the term Teradata Database is synonymous with Teradata Vantage.

Advanced SQL Engine is a core capability of Teradata Vantage, based on our best-in-class Teradata Database. Advanced SQL refers to the ability to run advanced analytic functions beyond that of standard SQL.

Using International Character Set Support

This document explains how to use international character sets with Vantage and includes information on:
  • Client and server character sets
  • Site-defined and extended site-defined client character sets
  • Collation sequences
  • Vantage character mapping

Why Would I Use this Content?

Use this content if you want to do the following:

  • Load and retrieve data in their local character set
  • Allow data to be exchanged through the database between different client character formats
  • Set or change collation

Do I Use this Content?

  • Look at the supported client character sets to determine the ones you need.
  • Look at the server character set options to determine the appropriate option for your needs.

How Do I Get Started?

You must perform various setup tasks to enable and use character set options.

Tasks 1 through 3 are required on all systems. Other tasks are optional, based on system needs.

  1. Make sure you understand how the Vantage system handles character data. See Character Sets and Object Names.
  2. Determine whether you can use system character set defaults or if you need to configure character set options. See System Default Character Support.
  3. Review the object naming topic to understand the rules that determine which characters are valid in object names for your system. See Object Names.
  4. Select and enable the client character sets that you need:
  5. If none of the Teradata-standard client character sets meets site needs, you can define a custom (site-defined) client character set:
  6. For information on default collation sequences and how to define and implement custom collation sequences, see Collation Sequences
  7. For detailed information on character conversion between client character sets and the server character set, including the option to define custom export widths for use during conversion to the client character set, see Character Conversion