hebrew in query reporter

[meiravm1]

Hi,
when I execute an identical query both in plsql-developer sql-window and report-window,
I get proper hebrew(IW) db columns output in the sql-window and improper hebrew db columns in the report window, even though they both rely on the registry NLS_LANG.
same goes if I run the query in the stand alone query reporter.(bad hebrew)
anyone knows how to set the query reporter nls_lang?
thanks

 

[Marco Kalter]

Like you say, the NLS_LANG is the same for both tools, so that can;t be it (unless you have multiple oracle homes).

Can you save the resulting HTML file from both PL/SQL Developer and Query Reporter and compare them? What are the differences?

 

[meiravm1]

Hi,
it worked out. I changed the regional settings to Israel and Hebrew and it's fine now.
also,I've found out that you can set the html character-set from pl/sql developer properties , which means changing the regional settings isn't required on pl/sql dev..but is there a way to do the same (set the html character-set) in query reporter?

 

[Marco Kalter]

No, such a setting does not exist for Query Reporter.

 

[meiravm1]

ok.so thanks for now.