Subject | Collation CASE SENSITIVE + ACCENT INSENSITIVE |
---|---|
Author | danyschaer |
Post date | 2009-02-10T16:25:20Z |
Hi;
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.
Dany
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.
Dany