Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateDDL statements → CHARACTER SET
Firebird Home Firebird Home Prev: DDL statementsFirebird Documentation IndexUp: DDL statementsNext: COLLATION

CHARACTER SET

Table of Contents

ALTER CHARACTER SET

Tip

Find a more recent version at Firebird 5.0 Language Reference: CHARACTER SET

ALTER CHARACTER SET

Available in: DSQL

Added in: 2.5

Description: With ALTER CHARACTER SET, the default collation of a character set can be changed. This will affect all future usage of the character set, except where overridden by an explicit COLLATE clause. The collation of existing domains, columns and PSQL variables will not be changed.

Syntax: 

ALTER CHARACTER SET charset SET DEFAULT COLLATION collation

Example: 

alter character set utf8 set default collation unicode_ci_ai

Notes: 

  • If you use SET DEFAULT COLLATION on the default character set of the database, you have effectively set (or overridden) the default collation for the database.

  • If you use SET DEFAULT COLLATION on the connection character set, string constants will be interpreted according to the new default collation (unless character set and/or collation are overridden). In most situations, this will make no difference, but comparisons may have another outcome if the collation changes.

Prev: DDL statementsFirebird Documentation IndexUp: DDL statementsNext: COLLATION
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateDDL statements → CHARACTER SET