Subject | RE: [firebird-support] collate problem |
---|---|
Author | PODESTA Mariano APRE |
Post date | 2003-07-17T20:13:22Z |
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