nvarchar column is displayed not correctly in the type

Gerf

Member
Hello! I have a problem with viewing result of select.
See details:
create or replace type Test_nchar as object ( F1_nvarchar2 nvarchar2(100), F2_varchar2 varchar2(100));
select to_nchar(t.object_name) correct_res, Test_nchar(to_nchar(t.object_name), t.object_name) as ctype from all_objects t where t.object_name like 'DBMS_OUTPUT';

Result - Field ctype.f1_nvarchar2 does not displayed correctly.

PL/SQL Developer Version 10.0.5.1710
Windows 7 (64-bit), OCI: version 11.1, Oracle Database 11g Release 11.2.0.3.0
Character Sets
Character size: 1 byte(s)
CharSetID: 178
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16
 
Hello!
I get the next result:

CORRECT_RES | CTYPE.F1_NVARCHAR2 | CTYPE.F2_VARCHAR2
DBMS_OUTPUT | 䑂䵓彏啔偕 | DBMS_OUTPUT
DBMS_OUTPUT | 䑂䵓彏啔偕 | DBMS_OUTPUT
 
Back
Top