Case sensitive in Laravel?

Question

Laravel

Good afternoon, how to get data from the database case sensitive.
Example:

$m = $test->where('name', 's1')->first(); // Результат: $m->id (1)
$m = $test->where('name', 'S1')->first(); // Результат: $m->id (5)

Answer 1

collate at the base/field. If you need this everywhere for this field, make the field utf8mb4_cs instead of utf8mb4_ci. The second option is to change where, like so:
->whereRaw("BINARY `name`= ?",[$name])