Bonjour,
J'ai ce message à la création de ma base grâce à un long script. Voici le message de Warning:
Warning! The maximum key length is 900 bytes. The index 'MYTABLE1_INDEX' has maximum length of 1109 bytes. For some combination of large values, the insert/update operation will fail.Operation failed. The index entry of length 1255 bytes for the index 'MYTABLE1_INDEX' exceeds the maximum length of 900 bytes.The statement has been terminated.
/Microsoft OLE DB Provider for SQL Server/Voici les indexes sur cette table MYTABLE1 (des champs varchar(50) et 2 champs INT)
CREATE UNIQUE INDEX [MYTABLE1_INDEX] ON [MYTABLE1] (
Type,
Name,
Value,
Active,
System
);
CREATE UNIQUE INDEX [MYTABLE1_2_INDEX] ON [MYTABLE1] (
Type,
Name,
Value,
Avay,
System
);Pourquoi ce warning? A cause des 2 indexes?
C'est quoi cette limitation de la taille des indexes?