| Subject | Re: Search ignoring special characters (accents etc) |
|---|---|
| Author | Werner F. Bruhin |
| Post date | 2008-07-16T10:06:16Z |
--- In firebird-support@yahoogroups.com, "Werner F. Bruhin"
<werner.bruhin@...> wrote:
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;
From within IBExpert's Script Executive but I get an error that this
operation is not defined for system tables.
What am I missing?
Werner
<werner.bruhin@...> wrote:
>search.
> I would like to search in a column ignoring any special characters such
> as accents, i.e. éüä etc.
>
> What is the best way of going about this?
>
> My database is using UTF8 character set for the columns I want to
>Searching some more I found information in the FB 2.1 doc about
> Appreciate any hints, documentation links ....
>
> Werner
>
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;
From within IBExpert's Script Executive but I get an error that this
operation is not defined for system tables.
What am I missing?
Werner