Primary Key – Case Sensitive

[AlanT]

I have defined a table with primary key of 1 character:

CREATE TABLE `itemtype` (

`ItemTypeCode` CHAR(1) NOT NULL,

`ItemTypeName` VARCHAR(50) NOT NULL,

PRIMARY KEY (`ItemTypeCode`)

) ENGINE=INNODB DEFAULT CHARSET=latin1;

INSERT INTO `itemtype`(`ItemTypeCode`,`ItemTypeName`) VALUES ('A','Normal'),('B','Bonus'),('D','Discounted');

I would like to add a record:

'a', 'allocated'

However, sqlYog did not allow me as duplicate key:

Duplicate entry 'a' for key 'PRIMARY'

Any way I can make it case sensitive for the primary key column?

[Author]

Posts