SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-35
The LC_CTYPE Section of a Collation Definition
The LC_CTYPE Section of a Collation Definition
The LC_CTYPE section defines character classes and case conversion rules.
The LC_CTYPE section can appear only once in a collation definition. Except for the
line that begins with class-name, each of the five types of lines shown in the syntax
diagram can appear only once in the section. Each type of line must begin on a new
physical line.
LC_CTYPE
starts an LC_CTYPE section.
charclass class-name [ ; class-name ] ...
specifies names for up to 100 user-defined character classes.
NonStop SQL/MP does not use character classes in any way, but does scan the
character class clause for correctness.
Each class-name can contain up to 30 letters or digits, but the first character
must be a letter. class-name must be unique within the collation definition and
cannot be any of these words:
class-name [class-element [; class-element] ... ] ]
specifies the set of characters from the character set to include in the class
class-name. class-element is normally a char, as defined in the discussion
of the LC_COLLATE section.
LC_CTYPE
[ charclass class-name [; class-name ] ...
class-name [class-element[; class-element] ... ] ]
[ toupper (lower,upper) [; (lower,upper) ] ... ]
END LC_CTYPE
charclass ISO88591 ISO88596 LC_CTYPE
forward ISO88592 ISO88597 LC_TDMCODESET
END ISO88593 ISO88599 toupper
from ISO88594 ISO88599 UNDEFINED
IGNORE ISO88595 LC_COLLATE UNKNOWN