Menu
▾
▴
RE: [Firebird-devel] Foreign-key, indicies same character-set but different collation ?
|
From: Claudio V. C. <cv...@us...> - 2002-09-02 10:46:38
|
Arno, can you please post in plain text? See how nice your message looks when viewed with the annoying HTML-email format turned off: > -----Original Message----- > From: fir...@li... > [mailto:fir...@li...]On Behalf Of Arno > Brinkman > Sent: Lunes 2 de Septiembre de 2002 5:51 > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=iso-8859-1" http-equiv=Content-Type> <META content="MSHTML 5.00.2920.0" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <DIV><FONT face=Arial size=2>Hi,</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>I want to know for sure if collations MUST be the same in a foreign key construction.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>For example :</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2> <DIV>CREATE TABLE Master<BR>(<BR> ID CHAR(5) CHARACTER SET ISO8859_1<BR> NOT NULL<BR> CONSTRAINT PK_Master PRIMARY KEY<BR> COLLATE ISO8859_1,<BR>);</DIV> <DIV> </DIV> <DIV>CREATE TABLE Detail<BR>(<BR> ID CHAR(5) CHARACTER SET ISO8859_1<BR> NOT NULL<BR> CONSTRAINT FK_TP_TARIEFGROEP<BR> REFERENCES TARIEFGROEP (TARIEFGROEPCODE)<BR> COLLATE DU_NL</DIV> <DIV> CONSTRAINT PK_Detail PRIMARY KEY (ID)<BR>);<BR></DIV> <DIV>ID (ISO8859_1 - DU_NL) references to ID (ISO8859_1 - ISO8859_1) does this causes problems ?</DIV> <DIV>Could an index-lookup fail in this situation ?</DIV> <DIV> </DIV> <DIV>Regards,</DIV> <DIV>Arno</DIV> <DIV> </DIV></FONT></DIV></BODY></HTML> |
