| Subject | problems with collate |
|---|---|
| Author | guido.klapperich@t-online.de |
| Post date | 2002-01-31T21:29:02Z |
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 ?
Guido
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 ?
Guido