>
> I have a table with a field PCNAME Varchar(200) character set ISO8859_1
> and with collate either DE_DE or ISO8859_1. There are 2 records 'ATV'
> and 'ape'. When I order by PCNAME I get the following result
> ATV
> ape
> with collate DE_DE and ISO8859_1. But it should be
> ape
> ATV
> because p comes before t. What am I doing wrong ?

The collation order is case sensitive and "A" (Ascii 65) is before "a"
(97).
So the ordering is correct.

Luc.