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).