Adriano dos Santos Fernandes wrote:

> Internal mechanism for default collations already work using
> RDB$CHARACTER_SETS.RDB$DEFAULT_COLLATE_NAME. They go to all the things
> the DEFAULT CHARACTER SET go. I extended it for string constants, based
> on the character set (client charset) of the constant.
>
> We just need DDL syntax for it, and I propose based on two feature requests:
>
> ----
>
> ALTER CHARACTER SET <charset name>
> SET DEFAULT COLLATE <collation name>
>
> Changes RDB$DEFAULT_COLLATE_NAME in RDB$CHARACTER_SETS.
>
> ----
>
> CREATE DATABASE ...
> [DEFAULT CHARACTER SET <charset name> [COLLATE <collation name>]]
>
> This do the same as the first command. Changes the default collation of
> the default character set.
>
> ----

I agree, but I think that they keyword COLLATION should be used instead
of COLLATE (see below).

> I also propose we make COLLATION and COLLATE words as having the same
> behavior, because we have the command CREATE COLLATION. Or anyone please
> say the difference and what should be used here.

AFAIU, COLLATE is a verb and its usage is: <value> COLLATE <rule>, which
means "to collate the value". But COLLATION is a noun which represent
the object we create/alter/drop.


Dmitry