16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

Any Shift-Out/Shift-In and trailing GRAPHIC pad characters are included in the result count.

OCTET_LENGTH operates in the same manner in both Teradata and ANSI modes.

IF string_expression is … THEN …
of type KANJI1 the result is independent of character_set_name.
not CHARACTER data an error is generated.

OCTET_LENGTH takes the export width value into consideration. For information about export width, see “CREATE USER” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

The following table lists the client character sets shipped with Teradata. Although these character sets are shipped with the system, your system administrator must install them individually to become available for use.

Your site might also have site-defined character sets. Check with your system administrator for a complete list of character sets available at your site.

Character Sets found in Built-in:
  • ASCII
  • EBCDIC
  • UTF8
  • UTF16
Character Sets found in DBC.CharTranslationsV:
  • EBCDIC037_0E
  • EBCDIC273_0E
  • EBCDIC277_0E
  • HANGULEBCDIC933_1II
  • HANGULKSC5601_2R4
  • KANJIEBCDIC5026_0I
  • KANJIEBCDIC5035_0I
  • KANJIEUC_0U
  • KANJISJIS_0S
  • KATAKANAEBCDIC
  • LATIN1252_0A
  • LATIN1_0A
  • LATIN9_0A
  • SCHEBCDIC935_2IJ
  • SCHGB2312_1T0
  • TCHBIG5_1R0
  • TCHEBCDIC937_3IB
Character Sets found in DBC.CharTranslationsV with Windows code page compatible session character set:
  • ARABIC1256_6A0
  • CYRILLIC1251_2A0
  • HANGUL949_7R0
  • HEBREW1255_5A0
  • KANJI932_1S0
  • LATIN1250_1A0
  • LATIN1252_0A
  • LATIN1254_7A0
  • LATIN1258_8A0
  • SCHINESE936_6R0
  • TCHINESE950_8R0
  • THAI874_4A0