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.
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