SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-29

COLLATE Clause

The COLLATE clause associates an existing collation with a character expression, with

a column of a character data type that is being added to a table, or with an index that is

being created.

For information about using the COLLATE clause on a character expression, see

Character Expressions on page C-14.

For information about using the COLLATE clause with a data type specification for a

CREATE TABLE or ALTER TABLE statement, see Data Types on page D-1.

For information about using the COLLATE clause to associate a collation with an

index, see CREATE INDEX Statement

on page C-142.

For general information about collations, see Collation Definitions

on page C-30.

For information about creating collations, see CREATE COLLATION Statement on

page C-137 and Collation Definitions on page C-30.