15.10 - Appendix E Mappings for String Functions - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

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.