How to configure sql query to be case sensitive?

Question

SQL

A query such as "SELECT * FROM user WHERE name='dima'" will also return results where name is equal to Dima, dima, etc. How to implement strict validation?

Answer 1

SELECT * FROM user WHERE name='dima'

SELECT * FROM user WHERE binary name='дима'
And specify the DBMS you are working with, your question is specific to MySQL.

Answer 2

Case sensitive look for your base. Diacritics and national standards are also important

Answer 3

In order not to write binary in the query as Vitsliputsli suggested , you can make a binary Collation (for example, utf8_bin or utf8mb4_bin) for the desired column. And add information about the DB, encoding, etc. to the question.