Question Regarding Unicode Support

[DR]

Hello All,

I just downloaded the new trail of PL/SQL developer to try out its unicode support feature that went into the earlier version 7 back last september.

I am still not getting Unicode characters when i query a database and open an XML clob. The XML returned in the clob does not appear to support the unicode as french characters come back as different characters.

If there is anything I am missing please let me know, I have checked and unicode is enabled in my options. Perhaps unicode just isnt supported within an xml clob brought back bo PL/SQL Developer?

Any info would be greatly appreciation.

Thanks
DR

 

[Marco Kalter]

Maybe this is an environment problem. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[DR]

Hi Marco,

Here you go:

--- Info ---

PL/SQL Developer
Version 7.1.1.1339
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1,047,920 kB (461,000 available)
Paging file : 1,734,660 kB (1,028,072 available)
Virtual memory : 2,097,024 kB (2,009,932 available)

Parameters
D:\program files\plsql developer7.1\PlSqlDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
D:\program files\plsql developer7.1\Preferences\Default\Default.ini
D:\program files\plsql developer7.1\Preferences\da14502\default.ini

Plug-Ins

Aliases
BIRPROD
EBPP2
EBPP3
EBPP3.CORP.XWAVE.COM
EBPP4
EBPP4.CORP.XWAVE.COM
EBPP920
EBPPCONS
EBPPCONS.CORP.XWAVE.COM

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.5.0

Character Sets
Character size: 1 byte(s)
CharSetID: 1
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: US7ASCII
NLS_NCHAR_CHARACTERSET: AL16UTF16

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora92
ORACLE_HOME_NAME = OraHome92
API = C:\oracle\ora92\dbs
ORACLE_GROUP_NAME = Oracle - OraHome92
NLS_LANG = NA
OLEDB = C:\oracle\ora92\oledb\mesg
VOBHOME2.0 = C:\oracle\ora92
OO4O = C:\oracle\ora92\oo4o\mesg

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = OraHome92
LAST_HOME = 0

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome92
PATH = C:\oracle\ora92
NLS_LANG = NA

SOFTWARE\ORACLE\AUTOTUNE9.2.0
help_path = ${vobhome2.0}bin/
debug_flags =
startlog = ${home}autotune/%1.log
trace_report = 0
trace_data = 0
collect_int_in_min = 15
analyze_int_in_hrs = 24
max_errors_allowed = 5
wip_batch = 0
wip_window = 0
wip_logfile = 0
wip_logtable = 0

SOFTWARE\ORACLE\EXPERT9.2.0
home = ${vobhome2.0}sysman/expert
help_path = ${vobhome2.0}bin/
xpcoin = ${vobhome2.0}bin/xpcoin
default_rule_file = xpo000
debug_flags =
sample = ${home}sample/
sample_xdl = ${sample}xppso.xdl
startlog = ${vobhome2.0}sysman/temp/xpexpert.log
trace_report = 0
trace_data = 0
max_orphan_txn_reqs = 100
max_cache_txn_reqs = 50
extract_explain_plan = 0
create_tmp_plan_table = 0
tmp_plan_table = xp_tmp_plan
wip_batch = 0
wip_window = 1
wip_logfile = 0
wip_logtable = 0
quicktour_start = ${vobhome2.0}classes/oracle/sysman/qtour/tune/us/tune.htm
report_viewer = write
startup_wizard = 1
collect_trace_stats = 1
standalone_mode = 0

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = C:\oracle\ora92
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\oracle\ora92\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
SQLPATH = C:\oracle\ora92\dbs
ORACLE_HOME_KEY = Software\ORACLE\HOME0
MSHELP_TOOLS = C:\oracle\ora92\MSHELP

SOFTWARE\ORACLE\iSQLPlus
ServerCount =

Thanks

 

[Marco Kalter]

Thanks, we'll check it out.

 

[DR]

Hi Marco,

Just wondering if there has been any update on this issue?

Thanks,
DR