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