Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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: http://docs.oracle.com/cd/B19306_01/server.102/b14225/ch13custlocale.htm

share|improve this answer

Your Answer

 
discard

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.