17.10 - How FORMAT Applies to Server Character Sets - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

The following table shows how FORMAT 'X(n)' applies to server character sets.

IF a string expression has this character set … THEN FORMAT 'X(n)' returns …
LATIN

GRAPHIC

UNICODE

n logical characters.
KANJI1

KANJISJIS

n bytes.

The character string in a FORMAT clause cannot be of type KANJI1. The form FORMAT

_Kanji1 ‘hex_digits’XC in particular always generates an error.