| Subject | changing default collation order |
|---|---|
| Author | Rolf & Sibylle Nussbaumer |
| Post date | 2003-12-07T06:08:57Z |
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?
Rolf Nussbaumer
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?
Rolf Nussbaumer