Subject | Re: unsuccessful metadata update, key size too big for index |
---|---|
Author | h_urlaf |
Post date | 2004-02-05T11:47:23Z |
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
Thanks,
Emiliano
> > When I try to create this table, I get the errorThat's what I figured, but the error is there nonetheless.
> > "unsuccessful metadata update, key size too big for index"
>
> From looking at the above DDL, I can't say that I think the
> keysize would be too big.
> What default characterset does this database have?UNICODE_FSS
> > 1. Break up this table into multiple tables, tie them togetherI figured that each table would only have two constraints max.
> > with foreign keys, and enforce uniqueness in each separate table.
> > A view could be used to bring them together.
>
> I have no idea why this should help.
Thanks,
Emiliano