Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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; 

With setting nls_comp and 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 ?

share|improve this question
up vote 1 down vote accepted

I think the Oracle Locale Builder utility is the tool that you want. The documention on the 10.2 version (since you've tagged with oracle-10g) of this utility is here:

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.