Subject Re: [firebird-support] Re: Collation CASE SENSITIVE + ACCENT INSENSITIVE
Author Mark Rotteveel
Since a lot of us read this list by mail and not on Yahoogroups, it
would be better to quote your original mail.

But to save you the trouble:

(mail on 10th of February)
"
Is it possible to use a CASE SENSITIVE + ACCENT INSENSITIVE collation?

In my database, for example, "A" must be considered different
thant "a", but "รก" must be considered = to "a".

So, I tried to do:

CREATE COLLATION ES_ES_AI
FOR ISO8859_1
FROM ISO8859_1
NO PAD
CASE SENSITIVE
ACCENT INSENSITIVE

but i get:

SQL Message : -607
This operation is not defined for system tables.

Thank you.
"

danyschaer wrote:
> Hi,
>
> Very sorry but, does somebody know the answer for this question?.
>
> Many thanks.
>
> Dany

--
Mark Rotteveel