oracle can't sort data in special persian characters

Question

I set oracle language to persian and store data as persian's characters in oracle Database,but when I sort data grid in oracle it can't sort by some special persian character like 'چ-گ-پ-ژ', in other words oracle does not sort data grid by this charactres:'چ-گ-پ-ژ'. can anyone help me?

Answer 1

There is 2 point and if you do theses be sure your Persian sorting would be works as well

1. Before installation of Oracle you should set your language in your OS (Persian Preferred)
2. After installation of Oracle find NLS_LANG key in OS Registry and change it to AR8MSWIN1256

Answer 2

You must add persian sort by "locale builder" ({ORACLE_HOME}/nls/lbuilder/lbuilder) tool then by nlt file generate nlb files(almost 5 files generated) then copy them to {ORACLE_HOME}/nls/data and done.

Creating a sort order may be time consuming because you must specify major and minor order per character. You can use arabic sort file (lx30015.nlb) as base sort file then save as nlt file and name it as persian_sort then add or verify the order of these characters: 'چ-گ-پ-ژ' and ک ك ی ي