Collation Order for a Column
From InterBase
Go Up to Specifying Character Sets
When a CHAR
or VARCHAR
column is created for a table, either with CREATE TABLE
or ALTER TABLE
, the collation order for the column can be specified using the COLLATE clause. COLLATE
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 ALTER TABLE.