Subject Re: [firebird-support] Re: Containing vs. Like
Author Helen Borrie
At 01:42 PM 23/09/2004 +0000, you wrote:

> >
> > Yes and no. They are not exactly the same. CONTAINING is
> > case-insensitive, in character sets that support uppercase/lowercase
> > mappings. A case-insensitive search can be more costly than a
> > case-sensitive one. Neither is fast, since indexes cannot be used to
> > assist these searches.
> >
>But what charsets support these mappings ?
>I trying with win1250, but UPPER is does not working with áé, so:
>"Kovács Ágnes" is uppered as "KOVáCS ÁGNES", and the FB is not found
>that record, when I type this SQL:
>SELECT * FROM persons
>where name containing 'kovács' and name containing 'ágnes'
>How to correct this problem ?

You would need to include the correct COLLATE sequence in your query,
unless the column itself is defined with it.

so -- SELECT * FROM persons
where name containing 'kovács' COLLATE PXW_HUN
and name containing 'ágnes' COLLATE PXW_HUN

>(I need to working with Linux and Windows, so if I create UDF-s, that
>everytime I need to redeclare UDF-s, when I copy the DataBase between OSs)