15.10 - KANJISJIS Server Character Set - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1143-151K

Japanese applications that rely on the KANJISJIS characteristics (for example, KANJISJIS physical space allocation).

ASCII SPACE (0x20)

CHARACTER(n) CHARACTER SET KANJISJIS

32000

This also is the size of LONG VARCHAR CHARACTER SET KANJISJIS.

The KANJISJIS type has a mixed single byte/multibyte character form-of-use of the KANJISJIS client character set.

The Teradata Database storage space allocation for this type is on a byte basis rather than character basis. When updating the field, truncation occurs based on this physical space.

All SQL string functions on this type operate on a logical character basis.

This type is included for third party tools that rely on the semantics of KANJISJIS, such as the string length or physical space allocation.

For details about the KANJISJIS server character set, see International Character Set Support.

CLOBs do not support the KANJISJIS server character set.