Available inDSQL

    Syntax

    Table 5.17.1.1 ALTER CHARACTER SET Statement Parameters

    The ALTER CHARACTER SET statement changes the default collation for the specified character set. It will affect the future usage of the character set, except for cases where the COLLATE clause is explicitly overridden. In that case, the collation sequence of existing domains, columns and PSQL variables will remain intact after the change to the default collation of the underlying character set.

    Note

    If you change the default collation for the character set that was specified during the connection, string constants will be interpreted according to the new collation value, except in those cases where the character set and/or the collation have been overridden.

    5.17.1.1 Who Can Alter a Character Set

    The statement can be executed by:

    • Users with the ALTER ANY CHARACTER SET privilege

    5.17.1.2 ALTER CHARACTER SET Example