case-insensitive search with 'binary'

[joonstar]

(1) Jane
(2) jane


I have the above data in myTable.


Let's look at the following code and its result.
code

select ID, Name
from myTable
where say like '%J%'

result

(1) Jane
(2) jane


The code above works fine.
But I have to use 'binary' for my own reason.
(I can't explain the my own reason because it's related to my mother tongue.)

Let's try to use 'binary' with the code above like the following.
code

select ID, Name
from myTable
where say like binary '%J%'

result

(1) Jane

code

select ID, Name
from myTable
where say like binary '%j%'

result

(2) jane


With 'binary' the code above is case-sensitive.

The following code doesn't work correctly. but it will show what I want.
would-be code1

select ID, Name
from myTable
where case-insensitive(say) like binary '%J%'

target result

(1) Jane
(2) jane


would-be code2

select ID, Name
from myTable
where case-insensitive(say) like binary '%j%'

target result2

(1) Jane
(2) jane

Is it possible to produce case-insensitive research with 'binary'?