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.
| string_expression Type | Result |
|---|---|
| KANJI1 | Result is independent of character_set_name. |
| Not CHARACTER | Error. |
OCTET_LENGTH takes the export width value into consideration. For information about export width, see CREATE USER.
The following table lists the client character sets shipped with Teradata, which your system administrator must install individually.
Your site may 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