Sample Header Ad - 728x90

Primary Key issue in MemSQL doesn't support case sensitive

1 vote
2 answers
271 views
Creating table in MemSQL and creating composite primary key. Lets create simple table with following structure: Table User Data Name userid Primary Key (userid) And assume application support case sensitive userid. So that following user id considered to be different: abc ABC Insert following data: 1) JOHN ABC b) ALEX abc Insert fails in MemSQL as it consider 'ABC' same as 'abc'. Please help me to understand if case sensitive primary key possible in MemSQL table or not.
Asked by Abhishek (21 rep)
Oct 15, 2019, 09:12 AM
Last activity: Jul 24, 2022, 09:01 PM