Exists a collation order, that is case-insensitive ?

Guido

Lucas Franzen wrote:

> >
> > 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.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/