How FORMAT Applies to Server Character Sets

Teradata Vantage™ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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.