List:General Discussion« Previous MessageNext Message »
From:SGreen Date:December 23 2004 7:01pm
Subject:Re: TINYTEXT field uniqueness question
View as plain text  
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 <listschris@stripped> 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/mysql?unsub=1
> 

Thread
TINYTEXT field uniqueness questionDenis Gerasimov22 Dec
  • Re: TINYTEXT field uniqueness questionChris23 Dec
    • Re: TINYTEXT field uniqueness questionSGreen23 Dec
    • RE: TINYTEXT field uniqueness questionDenis Gerasimov24 Dec