hi to all
I have a database with a lot of data and CHARACTER SET is NONE

I create a new BD with CHARACTERE SET WIN1252
I change my domains
from
CREATE DOMAIN "D_NOME_120" AS VARCHAR(120) NOT NULL;
to
CREATE DOMAIN "D_NOME_120" AS VARCHAR(120) CHARACTER SET WIN1252 NOT
NULL COLLATE PXW_INTL850;

I use InterbaseDataPump to import data, all works fine.

The problem is in key size.
Now when I try create an indice, in new BD, with same fileld VARCHAR
(120) but with a new character set I receive
"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.
What can I do to re-create this index?

thanks to all.