To me, that error means that you ALREADY HAVE duplicates in your data. You will have to eliminate the dupes before you can create the unique index.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Chris <[EMAIL PROTECTED]> wrote on 12/23/2004 01:55:34 PM: > 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] >
