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
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