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: