Case insensitivity of like query in MySQL5.7

for example, I like"% R% answer, the query results include not only R, but also r, which is not what I want, I want to be case-sensitive. I guess it has something to do with the proofreading rules of the table. My table uses utf8mb4 encoding, and the proofreading rule is utf8mb4_unicode_ci. (it seems that this proofreading rule does not have a"_ cs" suffix.) . How to solve the problem of asking for help from the great god?
how to write like binary in SQLAlchemy?


use like binary

Menu