Specifying Collation Order for a Column

Go Up to Specifying Collation Orders

Use the COLLATE clause with either CREATE TABLE or ALTER TABLE to specify the collation order for a CHAR or VARCHAR column. The COLLATE clause is especially useful for character sets such as ISO8859_1 or DOS437 that support many different collation orders.

For example, the following isql ALTER TABLE statement adds a new column to a table, and specifies both a character set and a collation order:

ALTER TABLE 'FR_CA_EMP'
ADD ADDRESS VARCHAR(40) CHARACTER SET ISO8859_1
 NOT NULL
 COLLATE FR_CA;

For the complete syntax of ALTER TABLE, see Language Reference Guide.