When specifying an index for TEXT and BLOB types, you must specify a length.
as an example...
CREATE TABLE test ( sValue TINYTEXT NOT NULL, UNIQUE KEY(sValue(90)) )
Denis Gerasimov wrote:
Hello,
Is that possible to ensure uniqueness for a TINYTEXT field? I tried to create an index (with UNIQUE constraint) but my GUI tool always says me 'Duplicate entry 'X' for key N'
Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
