Martijn,

> Just had a try with ISO8859_1, collation DU_NL -
> when I ORDER a column with these values:
>
> And
> AND
> aNd
>
> it ens up like:
>
> aNd
> And
> AND
>
>
> While using collation ISO8859_1 (the default), I get:
>
> AND
> And
> aNd
>
> So there does seem to be a difference there...

that's strange; I (almost clearly <g>) remember that (at least with
collation IT_IT which I once tried) the results were different; but
perhaps I'm confusing case sensitivity and accent sensitivity here.

> btw - when using the columns in a WHERE clause, they
> make no difference and never return "all" rows when doing
> = 'AND'

did you try

select ... from ...
where somefield collate DU_NL = 'AND' collate DU_NL

?
Or perhaps you have defined the collation at the column level and tried

select ... from ...
where somefield = 'AND' collate DU_NL

?

Since the comparisons must obey to the same rules whether they are done
for sorting and for filtering, if you experience different behaviour
there must be a bug somewhere.
Ciao
--
____
_/\/ando