17.05 - UPPERCASE Option and Character Parameter Definition in USING - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

When you specify UPPERCASE for a character parameter in a USING request modifier, it applies only to the single-byte characters of any mixed single-byte-multibyte character set.

To ensure uniform formatting as uppercase, do one of the following:
  • Define the column with the UPPERCASE attribute in CREATE TABLE or ALTER TABLE (for details, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144 and Teradata Vantage™ - Data Types and Literals, B035-1143).
  • Use the UPPER function to convert the lowercase characters to uppercase (see Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145).

See Character Data Import Process.