Case-insensitive search for like does not work

Question

MySQL

The actual query
SELECT *
FROM (
`users`
)
WHERE `username` LIKE '%JNC%'
LIMIT 0, 30 Looks for a

row with username MYJNC

And the query
SELECT *
FROM (
`users`
)
WHERE `username` LIKE '%jNC%'
LIMIT 0, 30

username varchar(50) encoding utf8_bin

Answer 1

I changed the encoding for the varchar to utf8_general_ci and everything was fine.

Answer 2

directly
upper(`username`) LIKE upper('%jNC%')
but in general dev.mysql.com/doc/refman/5.6/en/case-sensitivity.html