Hi all

I have a table on FB 9.4 test like this:

CREATE DOMAIN ID_DOM AS NUMERIC(18,0);

create table Java_Resources(
ID ID_DOM NOT NULL,
Application_ID ID_DOM not null,
Resource_Name VARCHAR(192) Character set none not null,
Resource_Data Blob not null,
Resource_Hash Varchar(128) Character set none not null,
Constraint Java_Resources_PrimaryKey Primary Key (ID),
Constraint Java_Resources_Unique Unique (Application_ID,
Resource_Name),
Constraint Java_Resources_Ref_JAppl Foreign Key (Application_ID)
References Java_Applications (ID)
);

When I try to create the same table on FB 1.0 it fails with this error
message:
-key size exceeds implementation restriction for index "RDB$99"
Statement failed, SQLCODE = -607
unsuccessful metadata update

If I change Resource_Name from VARCHAR(192) VARCHAR(188) I can create the
table.

The problem now is, I've got a db on FB 9.4 that I need to port to 1.0
including the data. How can I shrink the column size of Resource_Name?
(Alter table ... doesn't work)

Thanks,

Herbert