Subject | Re: Changing to UNICODE_FSS returns "key size to big on index" |
---|---|
Author | bmckenna6 |
Post date | 2006-10-13T18:00:54Z |
> For the create script, changing onlyI've tried creating smaller indexes. i.e., a separate
> DEFAULT CHARACTER SET WIN1252
> to
> DEFAULT CHARACTER SET UNICODE_FSS
>
> is returning the error:
>
> ISC ERROR CODE:335544351
> unsuccessful metadata update
> key size too big for index TYP1LAST1FIRST1IDX
>
> The index is based upon three fields:
> TYP1 BIGINT
> FirstString1 VARCHAR(36)
> LastString1 VARCHAR(84)
index for TYP1 BIGINT, and then a separate index for
LastString1 with FirstString1, but I'm getting the same
type of error message:
key size too big for index FIRST1LAST1IDX
How does one use UNICODE_FSS and indexes?