There is different letters for 'KAF' (ک , ك) and 'YA' (ی , ي) in Persian with different unicode codes and same spell.
I am using these commands to set Persian sort and comparing in my project
ALTER SESSION SET nls_sort=persian; ALTER SESSION SET nls_comp =linguistic;
nls_sort parameter I receieve these output
select first_name from customer where first_name like '%ك'; -- with result select first_name from customer where first_name like '%ک';--with no result
How can receive same output for these queries? Can I customize nls_comp ?