tags:

views:

40

answers:

0
Q: 

Oracle DUMP procedure returns question marks for Chinese characters

I am using Oracle 10g and am performing the following query:

SELECT DUMP('炫耀他的', 1017) FROM DUAL;

This outputs:

Typ=96 Len=4 CharacterSet=AL32UTF8: ?,?,?,?

Why have the Chinese characters been replaced with question marks? How do I get it to return the correct characters?

related questions

Dump of SQL Server insert data
Twitter Data Mining: Degrees of separation
Getting a dump of a process that crashes on startup
Importing two dmp files into single schema
How can I know the CLR version of a crash dump?
debug symbol issue
Error importing oracle dump
What is the JavaScript equivalent of var_dump or print_r in PHP?
Dumping a java object's properties
Can I selectively create a backup of Postgres database, with only certian tables?
Capturing a memory dump - .NET
Windows Server Crash Dump Analysis
Are explicitly typed regexes allowed as keys in Perl YAML dump?
How to get a heap dump of a Java process on Windows that's not running in a console
How do you identify (and get access to) modules/debug symbols to use when provided a windows .dmp or .minidmp
How to analyse a HTTP dump?
Retain Windows Error Reporting Dumps from Hung Application
Transfer Mysql database to another computer
How to generate the Symbols file of a PowerBuilder program for dump analysis?
How to dump data stored in objective-c object (NSArray or NSDictionary)
Generate dump with unmanaged code crash?
Database agnostic jdbc table import/export to files?
Is there an equivalent to Java's "kill -3" for a .NET CLR thread dump?
Convert a string representation of a hex dump to a byte array using Java?
How do you generate and analyze a thread dump from a running JBoss instance?