Usage Notes

Teradata Vantage™ SQL Functions, Expressions, and Predicates

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

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