Subject | Re: [firebird-support] changing default collation order |
---|---|
Author | Rolf & Sibylle Nussbaumer |
Post date | 2003-12-07T07:43:29Z |
Helen Borrie wrote:
Additional question
to alter the collation order of a column, I have to create a temporary
column with the desired collation order, then copy the data, right? Or
is it possible to use ALTER TABLE?
Rolf Nussbaumer
> At 07:08 AM 7/12/2003 +0100, you wrote:Thanks Helen
>
>>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.
>
> /heLen
>
Additional question
to alter the collation order of a column, I have to create a temporary
column with the desired collation order, then copy the data, right? Or
is it possible to use ALTER TABLE?
Rolf Nussbaumer