| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Kevin Riutort | Date: | October 18 1999 10:52pm |
| Subject: | Is a varchar primary key case sensitive? | ||
| View as plain text | |||
Is this a bug or is this the way MySQL (v.3.22.22) is supposed to work:
1) CREATE TABLE test (login varchar(10) NOT NULL, PRIMARY KEY(login));
2) INSERT INTO test (login) VALUES('USERNAME');
3) INSERT INTO test (login) VALUES('username');
--> ERROR 1062: Duplicate entry 'username' for key 1
I guess I was expecting that a varchar should be case sensitive.
Thanks,
Kevin
| Thread | ||
|---|---|---|
| • Is a varchar primary key case sensitive? | Kevin Riutort | 19 Oct |
| • Re: Is a varchar primary key case sensitive? | Bob Kline | 19 Oct |
