At 04:06 PM 13/04/2008, Dmitry Yemanov wrote:

>> 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, you took the words right out of my mouth. ;-)
Not to mention that COLLATE (not COLLATION or any other invention) is the keyword that *already* exists in Firebird's SQL grammar for the purpose of specifying a <collation order> *and* COLLATE is the SQL-92 keyword, to boot.

Helen