MySQL Bugs: #6176: search of a word in hebrew using LIKE return mistakes

Bug #6176	search of a word in hebrew using LIKE return mistakes
Submitted:	20 Oct 2004 10:20	Modified:	22 Oct 2004 16:52
Reporter:	peleg k	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.13	OS:	Windows (win2000)
Assigned to:		CPU Architecture:	Any

Description:
When i make this select : 
select b_name from budget  where b_name like '%&#1508;&#1500;&#1490;%'
i recive 2 line  :
&#1488;&#1493;&#1494;&#1504;&#1497;&#1493;&#1514; &#1500;&#1506;&#1502;&#1491;&#1493;&#1514; &#1513;&#1512;&#1493;&#1514; &#1500;&#1511;&#1493;&#1495;&#1493;&#1514;
&#1508;&#1500;&#1490;111

where only the second line is correct
and the first line dosnt contain at all!!!! the word &#1508;&#1500;&#1490; in hebrew and more then that
it dosen't even contain some of the letters!!!

How to repeat:
send me email to pelegk2@walla.co.il for more info

Thank you so much for writting to us.

4.0 does not have a proper support for character sets.

Your query should work in 4.1, if you setup column types, charsets and collations correctly. 

Please let us know if 4.1 does not work correctly.