Hi;

I am trying to create (FB 2.5) a special collation ACCENT INSENSITIVE.

So I added ES_ES_AI into the INTL.CONF and then tried to create, but
I get an error:

Executing...
*** IBPP::SQLException ***
Context: Statement::Execute( CREATE COLLATION ES_ES_AI FOR ISO8859_1
FROM ISO8859_1 ACCENT INSENSITIVE )
Message: isc_dsql_execute2 failed
SQL Message : -607
This operation is not defined for system tables.
Engine Code : 335544351
Engine Message :
unsuccessful metadata update
Invalid collation attributes

It works fine if I do:

CREATE COLLATION ES_ES_AI
FOR ISO8859_1
FROM ISO8859_1
NO PAD
CASE SENSITIVE

But it works wrong again if I do:

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

I need to get a COLLATION that CASE SENSITIVE/ACCENT INSENSITIVE; is
that possible?

Dany