UTF8 Client Character Set Support | Teradata Vantage - 17.20 - UTF8 Client 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)

The Teradata Universal Coded Character Set Transformation Format (UTF8) client character set supports UTF8, a standard way of encoding Unicode character data that is optimized for backward compatibility with ASCII. This character set is usable for all languages. In Teradata UTF8, a character can consist of one to three bytes.

The UTF8 client character set is permanently enabled for use in Advanced SQL Engine.

IF a byte in a UTF8 string is … THEN it …
less than 0x80 represents the same character defined by standard ASCII.
greater than or equal to 0x80 is part of a multibyte sequence and is not a standard ASCII character.