Subject | Re: [firebird-support] Re: Collation CASE SENSITIVE + ACCENT INSENSITIVE |
---|---|
Author | Mark Rotteveel |
Post date | 2009-03-11T14:37:54Z |
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:
Mark Rotteveel
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