DROP TABLE IF EXISTS TestTable;

CREATE TABLE TestTable (
  Name varchar (255) CHARACTER SET ucs2 COLLATE ucs2_bin NOT NULL,
  CONSTRAINT MY_UNQ_UK UNIQUE(Name)
) ENGINE=InnoDB;

INSERT INTO TestTable(Name) VALUES('ﾫ');
INSERT INTO TestTable(Name) VALUES('ﾫﾭ');

-- only the first record is returned
SELECT Name FROM TestTable WHERE Name LIKE 'ﾫ%';

-- DROP INDEX MY_UNQ_INDEX
DROP INDEX MY_UNQ_UK ON TestTable;

-- both records are returned
SELECT Name FROM TestTable WHERE Name LIKE 'ﾫ%';