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?
Best regards
Joacim Järkeborn
Sweden
---------------------------------------------------------------------
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