Subject Re: [ib-support] key size ok to character set none byt too big with WIN1252
Author Claudio Valderrama C.
""enio_bueno"" <enio_bueno@...> wrote in message
news:9vo392+a41l@......
>
> "Unsuccessful metadata update
> key size too big for index ACERVO_BY_SUB_TITULO"
>
> I can't reduce size of column becouse there is records with 120
> characteres.

This is a limitation by design. There's nothing you can do to overcome it.

You could try www.brookstonesystems.com because a case-insensitive collation
driver takes less space to index the same entry than a built-in case
sensitive collation driver.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing