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
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval

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.