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.

Advance To: