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