searching arabic words that have diacritics in mysql -

to make question simple knows why query returns true

select 'الجنة' ='الْجِنَّةِ' collate utf8_unicode_ci ; 

while query returns false

select 'الجنة' '%الْجِنَّةِ%' collate utf8_unicode_ci ; 

and how let later returns true ? .

i think want read on match... against... handling "natural language full-text searches"

i loaded example given mysql.com sql fiddle, modifying include arabic string , worked expected.

see sqlfiddle here: http://sqlfiddle.com/#!2/92317/1

update answer include additional parameters added asker

(now uses boolean mode , defines charset , collation)

updated sqlfiddle @nyran91: http://sqlfiddle.com/#!2/4a7004/3

create table articles ( id int unsigned auto_increment not null primary key, title varchar(200), body text, fulltext (title,body) ) engine=myisam default charset=utf8 collate=utf8_unicode_ci;   insert articles (title,body) values ('الْجِنَّةِ dckiew', 'davadv الْجِنَّةِ avadv')   select * articles match (title,body) against ('الجنة' in boolean mode);