making unique keys in mysql

[shaddf]

I have this table:

CREATE TABLE _HRatortbl (

  Hor_id INT unsigned NOT NULL auto_increment,
  Hicator_title  longtext NOT NULL,
 
  Primary KEY(HRindicator_id),

 UNIQUE KEY  ix_length_HRindicator_title (HRindicator_title(255))
)ENGINE=InnoDB DEFAULT CHARSET=utf8

why is it that it cannot differentiate between:

Legally stipulated Age for marriage

and

legally stipulated age for mariage

 

I found them both iniside the table .Is there another way to do this on text fields

[Jacques1]

So you want case-sensitive string comparison? Then you need to use a case-sensitive collation like utf8_bin for the column or the entire table.

Edited September 17, 2015 by Jacques1

[secweb]

No expert on this but looks like you need the COLATE keyword

 

http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html

http://stackoverflow.com/questions/6448825/sql-unique-varchar-case-sensitivity-question

 

The second link has an example:

 

CREATE TABLE WORDS (
    ID BIGINT AUTO_INCREMENT, 
    WORD VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_cs NOT NULL UNIQUE, 
    PRIMARY KEY(ID)
);