Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fields with Hebrew content are exported as gibberish ("????")

713961Jul 26 2009 — edited Jul 27 2009
Fields with hebrew content are exported as gibberish ("????") from Agile PLM version
9.2.2.4 (Oracle 10g).

The hebrew content was imported to Agile (oracle) via API code.
We apply Sergiusz solution to import the hebrew (first we encountered problems ):
"Your API actually calls Agile API. As I have not much time at the moment, I will assume that Agile API does a standard JDBC connection to Oracle and properly processes String field objects. In such case, do the following changes:

In Windows Registry, in "HKLM\SOFTWARE\Systematics LTD\Agile\Oracle2Agile", add another string parameter called FileEncoding. Set its value to: windows-1255

In BackToAgile.java, change these lines:

file= Login.getRegParam("File");
BufferedReader in = new BufferedReader(new FileReader(file));

to these lines:

file = Login.getRegParam("File");
String fileEncoding = Login.getRegParam("FileEncoding");
BufferedReader in = new BufferedReader(new InputStreamReader(new
FileInputStream(file),fileEncoding));

If it does not help, I will research further."

Before we apply the following solution the hebrew content appears as gibberish ("????") in Agile, but was exported successfully.

Please advice.

Regards,
Orly Tor
Systematics

Please update me in : orlyt@systematics.co.il
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2009
Added on Jul 26 2009
1 comment
3,149 views