I'm working with charset ISO8859_1
my table is :
CREATE TABLE test
(RSDGI VARCHAR(67) NOT NULL COLLATE FR_FR,
CODE_DEPT CHAR(3) NOT NULL,
CODE_COMMUNE CHAR(3) NOT NULL,
CODE_VOIE CHAR(4) NOT NULL COLLATE FR_FR,
RS VARCHAR(67) NOT NULL COLLATE FR_FR
);

Of course a unique key or a primary key on
(RSDGI,CODE_DEPT,CODE_COMMUNE,CODE_VOIE) is too long
but I have to be sure that a record based on
(RSDGI,CODE_DEPT,CODE_COMMUNE,CODE_VOIE) is unique, how can I do ?


--
Philippe Makowski
A6-CMO
20 rue Martin Bernard 75013 Paris France
Téléphone/Office : +33 1 53 62 71 51
Ligne Directe/Direct line : +33 5 61 05 88 13
Fax : +33 1 53 62 71 54
http://www.a6cmo.fr

Firebird serveur SQL open-source en français
http://firebird-fr.eu.org

Ma clé PGP : http://makowski.eu.org/pgpkey.html