Subject | Re: character set error on open table |
---|---|
Author | ronaldorezende |
Post date | 2003-03-12T17:06:14Z |
> There might be a string error somewhere in this system query, whereyou
> have added a constraint somewhere that has a name that is too longor uses
> an illegal character. (The limit is 31 characters, and you arerestricted
> 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);