Hi all,

Does anybody know why ACCENT INSENSITIVE doesn't work with the
ISO8859_1_UNICODE collation? This statement:

create collation lat_uni for iso8859_1
from external ('ISO8859_1_UNICODE') accent insensitive

gives the following error:

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

The other five standard attributes (including accent sensitive)
all work.

If I create the collation from e.g. external ('ES_ES'), both
accent sensitive and accent insensitive are accepted.

Especially from the _UNICODE collations I would expect that they
support both accent sensitive and accent insensitive.

Can somebody enlighten me?


Cheers,
Paul Vinkenoog