Mysql's LIKE is missbehaving with Hebrew and backslashes, why?

Question

I have the following SQL query which returns the correct results:

SELECT *
FROM `tags`
WHERE tag_name = 'בית\\\"ר-ירושלים'

If I change it to

SELECT *
FROM `tags`
WHERE tag_name LIKE 'בית\\\"ר-ירושלים'

or to

SELECT *
FROM `tags`
WHERE tag_name LIKE 'בית\\\"ר-ירושלים%'

It doesn't work. It will work if I remove all the backslashes and " from the query.

Answer 1

As @halocursed said - this is a bug in MySql.
bugs.mysql.com/bug.php?id=46659