Subject RE: [firebird-support] collate problem
Author PODESTA Mariano APRE
thank you, ivan. got it.

> -----Original Message-----
> From: PUB: Ivan Prenosil [mailto:Ivan.Prenosil@...]
> Sent: MiƩrcoles, 16 de Julio (7) del 2003 19:18
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] collate problem
>
>
> From: "PODESTA Mariano APRE"
> > why a case-insensitive collate like ES_ES or EN_US works
> for SORT and not
> > for WHERE?
>
> Because these are not case-insensitive collations.
> They just use dictionary sort where case of letters has less
> significance than the letter itself.
>
> Ivan