List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 27 1999 1:34am
Subject:Re: Unique key size and dupes
View as plain text  
At 3:46 PM -0500 9/26/99, John Jacques wrote:
>Well, I first thought there was a bug using unique fields (as shown
>below), but, then I discovered I have the first field size to 5 chars,
>so it explains my problem (stupidity :).
>OK, so when this situation happens shouldn't mysql give an error message
>telling us that the field size is exceeded rather then a duplicate error
>Just a thought.
>John Jacques

Well ... no.  If you declare a column to be 5 characters long, then you
shouldn't be trying to stuff longer values into it.

The manual documents that if you try to put a value into a string column
that's too long, the value is truncated.

Paul DuBois, paul@stripped
Unique key size and dupesJohn Jacques26 Sep
  • Re: Unique key size and dupesPaul DuBois27 Sep