Case sensitive (binary) search on MySQL?

[fungus75]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

statement = select(Call).where(Call.hashid == call_hash)

Description

I have a table called "call": In this table Video-Calls are stored.
I create a hash-id (hashid) field which should be case-sensitive, e.g. JPe9gxdjRULnpL9mQ9jy2eHgWSyeoLrm6LAGgmrtbhNH4LIN9D

Now I do want to search binary-safe or Case-Sensitive.
Because it doesn't mather if I search for JPe... or jpe... in both cases the above entry was found.

Googling around: mysql has a default feature: performing case insensitive searches. See: https://stackoverflow.com/questions/7857669/mysql-case-sensitive-query

How can I force sqlmodel to do so?

Operating System

Linux

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

Python 3.11.10

Additional Context

No response