Issue with special characters in SQL -

i have table following

create table test(name nvarchar(100))  insert test(name) values (n'ἀἁἃἄὠἀἁἃἄὠἀἁἃἄὠἀἁἃἄὠἀἁἃἄὠἀἁἃἄὠἀἁἃἄὠ1,') insert test(name) values (n'ἀἁἃἄὠἀἁἃἄ') insert test(name) values (n'test')  select * ed.test name n'ἀἁἃἄὠἀἁἃἄ' 

this above select query should return 2 results returning 1 result.

this statement

select * ed.test name '%ἀἁἃἄὠἀἁἃἄ%'  

not returning result.

select * ed.test name n'%ἀἁἃἄὠἀἁἃἄ%'  

returning result.

what missing?

for special languages characters should use collate.

select * test  name  collate greek_100_cs_as_ks_ws_sc  n'ἀἁἃἄὠἀἁἃἄ%' 

sql fiddle demo

for solution used collation_name greek_100_cs_as_ks_ws_sc

below query returns possible collation_name

select * ::fn_helpcollations() 

you can chose collation_name suits you.