Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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
like image 476
mahnaz ebrahimi Avatar asked Apr 14 '15 05:04

mahnaz ebrahimi


1 Answers

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
like image 174
mahnaz ebrahimi Avatar answered Oct 17 '22 13:10

mahnaz ebrahimi