DOWNSHIFT attribute

The DOWNSHIFT attribute forces character input to lowercase letters.

Syntax

DOWNSHIFT

Usage

Assign the DOWNSHIFT attribute to a character field to automatically convert uppercase letters entered by the user to lowercase letters.

Because uppercase and lowercase letters have different values, storing character strings in one or the other format can simplify sorting and querying a database.

The results of conversions between uppercase and lowercase letters are based on the locale settings.