Appendix E Mappings for String Functions - Teradata Database

International Character Set Support
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

This appendix provides internal mappings that Teradata Database uses for the TRANSLATE, LOWER, and UPPER functions.

The following mappings apply to the TRANSLATE function:

  • “Pad Character Translation” on page 205
  • “Space Folding” on page 206
  • “Non-GRAPHIC Characters” on page 207
  • “UNICODE Halfwidth to Fullwidth” on page 212
  • “UNICODE Fullwidth to Halfwidth” on page 213
  • “UNICODE to LATIN” on page 222

    • For the UNICODE to KANJISJIS mapping used by the TRANSLATE function, see “UNICODE to KanjiShiftJIS Single-Byte” on page 343.

    The following mapping applies to the LOWER function:

  • “LATIN Uppercase to Lowercase” on page 230
  • “UNICODE Uppercase to Lowercase” on page 281

    • The following mappings apply to the UPPER function:

  • “Multibyte KANJISJIS Lowercase to Uppercase” on page 233
  • “Single-Byte KANJISJIS Lowercase to Uppercase” on page 237
  • “UNICODE Lowercase to Uppercase” on page 238

    • For details on the TRANSLATE, LOWER, and UPPER functions, see SQL Functions, Operators, Expressions, and Predicates.