Search code examples
oracleunicodeutf-8weblogicfarsi

Persian character encoding in oracle database

I have got a problem with saving Persian characters like ("ی" or "ک") into oracle database. I receive correct encoding from a client, but when I insert the related record into the database, it will be saved with Arabic encoding like this ("ي").

The specifications of my application are:

  • WebLogic application server 12c on Linux
  • Oracle 11 g (thin driver)
  • OpenJPA 2.2.2

I set the following properties into WebLogic setting file, but it did not work.

export NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG=AMERICAN_AMERICA.UTF8
-Dfile.encoding=UTF-8
Solution

  • By adding following properties into weblogic setting ('JAVA_OPTIONS' part of setDomainEnv.sh file), my problem has been resolved by help of this link

    -Doracle.jdbc.defaultNChar=true 
-Doracle.jdbc.convertNcharLiterals=true