I am using EMBEDDED Firebird 2.1.2 and have a table with the following
columns:

"PATH" VARCHAR (256) NOT NULL *COLLATE UNICODE_CI*,
"MAJOR_VERSION" INTEGER NOT NULL,
"MINOR_VERSION" INTEGER NOT NULL,
"MACHINE_ID" CHAR (38)

When I try to create a unique index on ("MACHINE_ID", "PATH",
"MAJOR_VERSION", "MINOR_VERSION") Firebird throws the following exception:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351. unsuccessful
metadata update
key size exceeds implementation restriction for index

However, the same index creation succeeds if I *remove* *COLLATE UNICODE_CI
*from "PATH" column definition.

The database is configured to use 16K pages.

What is the problem? Will this be fixed by upgrading to Firebird 2.1.3
(embedded)?

Thanks,

Alec


[Non-text portions of this message have been removed]