[Firebird-devel] Foreign-key, indicies same character-set but different collation ?

[Arno B. <fir...@ab...>]

Hi,

I want to know for sure if collations MUST be the same in a foreign key =
construction.

For example :

CREATE TABLE Master
(
  ID CHAR(5) CHARACTER SET ISO8859_1
    NOT NULL
    CONSTRAINT PK_Master PRIMARY KEY
    COLLATE ISO8859_1,
);

CREATE TABLE Detail
(
  ID CHAR(5) CHARACTER SET ISO8859_1
    NOT NULL
    CONSTRAINT FK_TP_TARIEFGROEP
      REFERENCES TARIEFGROEP (TARIEFGROEPCODE)
    COLLATE DU_NL
  CONSTRAINT PK_Detail PRIMARY KEY (ID)
);

ID (ISO8859_1 - DU_NL) references to ID (ISO8859_1 - ISO8859_1) does =
this causes problems ?
Could an index-lookup fail in this situation ?

Regards,
Arno