CODEWITHSUNDEEP
oracle-databaseunicodeutf-8weblogicfarsi
mahnaz ebrahimi
mahnaz ebrahimi

Reputation: 111

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:

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

Upvotes: 7

Views: 3465

Answers (1)

mahnaz ebrahimi
mahnaz ebrahimi

Reputation: 111

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

Upvotes: 3

Related Questions