Oh, sorry Mark, I didn't see your answer until now.

My database says it is ODS 11.2 (where do I set that?, I use FlameRobin for creating the database).

Please can you tell me the steps you did for making this command running:

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

BTW, I am testing with 2.5 snapshot 23239.

Thank you.


Dany

--- In firebird-support@yahoogroups.com, Mark Rotteveel <Avalanche1979@...> wrote:
>
> I am no expert on the collations in Firebird, but the CREATE COLLATION
> is new in Firebird 2.1, so two questions:
>
> * Are you using Firebird 2.1?
> * Is your database ODS 11.1?
>
> On my Firebird server (2.1.1.17910) with an ODS 11.1 database, your
> create collation command works fine.
>
> Mark
>
> danyschaer wrote:
> > Thank you Mark.
> > Do you know something about this point?.
> >
> > --- In firebird-support@yahoogroups.com, Mark Rotteveel <Avalanche1979@> wrote:
> >> 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.
> >> "
> --
> Mark Rotteveel
>