Subject Re: [firebird-support] changing default collation order
Author Helen Borrie
At 07:08 AM 7/12/2003 +0100, you wrote:
>dear list
>a database contains exclusively german text. As far as I understand the
>concept, setting the database's character set to ISO8859_1 will allow to
>use the collation clause COLLATE DE_DE to force correct sorting. Adding
>this clause to every ORDER BY statement looks quite awkward to me.
>Is there a way to set DE_DE as default collation clause in the database?

At column level, when you define the column, you can specify a COLLATION
clause. Then, that column will always be sorted in that order unless you
specify a different one.