On 15-Aug-2001 Järkeborn Joacim wrote:
> Hi,
>
> I have the table:
>
> CREATE TABLE WI_TEXTLISTUS (
> TEXTID VARCHAR(50) NOT NULL,
> COUNTRY VARCHAR(2) NOT NULL,
> LANGUAGE VARCHAR(3) NOT NULL,
> TEXT VARCHAR(250),
> PRIMARY KEY (TEXTID,COUNTRY,LANGUAGE),
> INDEX TEXTLISTUS_X1 (TEXT)
> );
>
> and when I inserts data such as
>
> INSERT INTO WI_TEXTLISTUS VALUES ('IUSB-2348a-n00021','US','eng','FUEL TANK
> SUPPORTS, LH');
> INSERT INTO WI_TEXTLISTUS VALUES ('IUSB-2348A-N00021','US','eng','FUEL TANK
> SUPPORTS, LH');
>
> I get an error:
>
> ERROR 1062: Duplicate entry 'IUSB-2348A-N00021-US-eng' for key 1
>
> Is it possible to set mySQL to be case sensitive since it's a small
> difference between the two?
>
TEXTID VARCHAR(50) BINARY NOT NULL,
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php