Primary Key issue in MemSQL doesn't support case sensitive
In order to make primary key to support case sensitive, binary character set helps in this.

To set binary character set at database level, following command can be used:
SET collation_connection = 'utf8_bin';

To set at column level, following command can be used:
create table CaseSensitive ( name varchar(5) binary, age int, primary key(name));