Usage Notes - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™

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