Werner F. Bruhin escreveu:

> --- In firebird-support@yahoogroups.com, "Werner F. Bruhin"
> <werner.bruhin@...> wrote:
>> I would like to search in a column ignoring any special characters such=20
>> as accents, i.e. =E9=FC=E4 etc.
>> =20
>> What is the best way of going about this?
>> =20
>> My database is using UTF8 character set for the columns I want to
> search.
>> =20
>> Appreciate any hints, documentation links ....
>> =20
>> Werner
>>
> Searching some more I found information in the FB 2.1 doc about
> collations and as there doesn't seem to be a Unicode collation which
> ignores case and accent I tried to use:
>
> CREATE COLLATION UNICODE_CI_AI
> FOR UTF8
> FROM UNICODE
> CASE INSENSITIVE
> ACCENT INSENSITIVE;
>

This collation is only present in V2.5. There are
case-/accent-insensitive collations for others character sets. You could
see a list of them in ISQL with "show system collations" command.


Adriano