How to make loadByProperties or entityQuery case sensitive for field value

Question

Neither loadByProperties or entityQuery are case sensitive. How to make it case sensitive? I'm using MySQL as a database but would rather have a portable solution if possible.

With LoadByProperty

$nodes = $this->entityTypeManager()
              ->getStorage('node')
              ->loadByProperties(['field_myfield' => $value]);

With entityQuery

    $entity_ids = \Drupal::entityQuery('node')
        ->condition('field_myfield',$value)
        ->execute();

You can, of course, build your own query as explained in this answer. But my question is specifically about using loadByProperties or entityQuery API.

Answer 1

It was this long issue thread, they add sensitive case support to entityQuery.

So instead of = operation you can use = BINARY or instead of LIKE you can use LIKE BINARY.
Try this:

$entity_ids = \Drupal::entityQuery('node')
  ->condition('field_myfield',$value, '= BINARY')
  ->execute();