Subject Re: character set error on open table
Author ronaldorezende
> There might be a string error somewhere in this system query, where
you
> have added a constraint somewhere that has a name that is too long
or uses
> an illegal character. (The limit is 31 characters, and you are
restricted
> to using US ascii characters in identifiers).

Thank you.
I have found what is wrong. My script has this character "Ç" in the
name of constraints.
How can I change the name of these foreign key? (my program don't
show me the constraints of this table).

alter table TEM_ENDERECO
add constraint "FK_ENDERECO_TEM_PARÇEIRO" foreign key (ID_PARCEIRO)
references PARCEIRO (ID_PARCEIRO);

alter table TEM_ENDERECO
add constraint "FK_PARCEIRO_TEM_ENDEREÇO" foreign key (ID_ENDERECO)
references ENDERECO (ID_ENDERECO);