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 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.

--
Adriano dos Santos Fernandes
http://www.firebirdsql.org