> I'm using Firebird 1 and it seems, that the Collation DE_DE doesn't work
> correctly. Here's the test-scenario:
>
> CREATE TABLE TEST (
> SORT_DE VARCHAR(10) CHARACTER SET ISO8859_1 COLLATE DE_DE,
> SORT_ISO VARCHAR(10) CHARACTER SET ISO8859_1 COLLATE ISO8859_1
> );

...

> select * from TEST order by SORT_DE asc
> The result is:
> SORT_DE SORT_ISO
> -------------------------
> , ,
> A A
> ,A ,A
> A, A,
> GA GA
> G,A G,A
> GA, GA,
>
> This result is NOT correct. Am I doing something wrong, or is this an
> error of DE_DE-Implementation ?

The result is correct, or "as designed", because non-binary collations
implement so called "dictionary order", where punctuation marks
(like spaces and commas) are of the lowest priority.

Ivan
http://www.volny.cz/iprenosil/interbase