View Or Edit View Gets Unicode Characters as ?

[Givi]

Hello,

My Problem is related to viewing or editing views(context Menu - Mouse Right click) containing unicode characters. It shows ? characters instead of unicode characters.

I have no problems retrieving data from tables and views. It's OK.

Here is my Support Info:

--- Info ---

PL/SQL Developer
Version 9.0.4.1644
02.75482 - 20 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2,088,296 kB (1,270,732 available)
Paging file : 4,026,800 kB (3,059,360 available)
Virtual memory : 2,097,024 kB (1,976,144 available)

Parameters
C:\Program Files\plsql developer 9\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files\plsql developer 9\Preferences\Default\Default.ini
C:\Program Files\plsql developer 9\Preferences\giviut\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files\plsql developer 9\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\plsql developer 9\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\plsql developer 9\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\plsql developer 9\PlugIns\VCS.dll)
(* is Active)

Aliases
BANK10GG
ERPDB
XE

Homes
DevSuite (D:\DevSuite)
Discoverer10g (D:\Discoverer10g)
Oracle10g (D:\oracle10g)
Oracle9i (D:\Oracle9i)
oracleas1 (D:\OracleAS)
Orant (D:\Orant)
XE (D:\oraclexe\app\oracle\product\10.2.0\server)

DLLs
D:\oracle10g\bin\oci.dll

TNS File
D:\oracle10g\Network\Admin\tnsnames.ora

Using
Home: Oracle10g
DLL: D:\oracle10g\bin\oci.dll
OCI: Version 10.2
Oracle9i Enterprise Edition Release 9.2.0.1.0

Character Sets
Character size: 3 byte(s)
CharSetID: 0
NCharSetID: 873
Unicode Support: False
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

Please help.

Givi

 

[Marco Kalter]

It should work fine. Can you query the same Unicode source from the sys.all_source view?

 

[Givi]

Marco,

Thank you for the response.
If you mean sys.all_views than yes, I see unicode characters.

 

[Marco Kalter]

What happens if you copy that text to the editor of a Program Window?

 

[Givi]

It appears as unicode characters

 

[Marco Kalter]

Can you send me the source file with correct unicode characters by e-mail?

 

[Givi]

Marco,

Sorry for a late response. What do you mean under source file?

Givi

 

[Marco Kalter]

I mean the "crate or replace view" statement with the correct Unicode characters. Can you save it as a file and send it by e-mail?

 

[Givi]

Dear Marco,

Please check email: support@allroundautomations.com. I've sent the create view statement there.

Givi

 

[Givi]

Dear Marco,

Could you please provide us with the solution. We still in a trouble.

Givi

 

[Marco Kalter]

I don't think we received your e-mail? Can you re-send it?

 

[Givi]

Sent you email again. please check support@allroundautomations.com

Givi