Oracle DUMP procedure returns question marks for Chinese characters

Posted by PeteDaMeat on Stack Overflow See other posts from Stack Overflow or by PeteDaMeat
Published on 2010-04-14T15:51:04Z Indexed on 2010/04/14 15:53 UTC
Read the original article Hit count: 341

Filed under:

oracle10g

|

character-encoding

|

dump

|

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?

© Stack Overflow or respective owner

Related posts about oracle10g

How to set _optimizer_search_limit and _optimizer_max_permutations in Oracle10g.

as seen on Server Fault - Search for 'Server Fault'
I am working on a product that must support both MSSQL and Oracle (10g and 11g). I have some very complex queries that seem to run without issue on MSSQL 2005/2008, but very, very slow with Oracle. The CPU on the oracle server skyrockets for long periods of time, and it seems like the optimizer… >>> More
Any suggestions on how to extract 6 million records from an oracle10g ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I just want to give you a little background Need to write a PL-SQL which will extract 6 million record joining different tables and create a file of that. Need more suggestions, specifically on how to fetch these many records. As fetching these million of records on a single go can be a highly resource… >>> More
How to write a optimized code to fetch 6 million records from Oracle10G database and write them on a

as seen on Stack Overflow - Search for 'Stack Overflow'
What to use in oracle 10G to extract 6 million records and create a flat file of it ? >>> More
how to know the names of other users in oracle10g?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi guys,i want to know how can we know the other users of oracle 10g on the same system. Is there any querry for that? thank you!!! >>> More
Where is the C precompiler for Oracle10g located?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a newer version of the Pro*C/C++ to upgrade my procui.exe 9.0.1.1.1. I downloaded the 10g client disk and when install I have the following options: instant client administrator runtime custom I dont seem to able to find the actual program other than just getting some… >>> More

Related posts about character-encoding

Harmonizing Character Encoding Between Imported Data and MySQL

as seen on Internet.com - Search for 'Internet.com'
MySQL's Latin-1 default encoding combined with MySQL 4.1.12's (or greater) UTF8 encoding allows the maximum number of characters codes, however incoming data with different character encoding can still present problems. Rob Gravelle shows you how to avoid problems before a lot of work is required… >>> More
Harmonizing Character Encoding Between Imported Data and MySQL

as seen on Internet.com - Search for 'Internet.com'
MySQL's Latin-1 default encoding combined with MySQL 4.1.12's (or greater) UTF8 encoding allows the maximum number of characters codes, however incoming data with different character encoding can still present problems. Rob Gravelle shows you how to avoid problems before a lot of work is required… >>> More
How to cross-reference many character encodings with ASCII OR UTFx?

as seen on Programmers - Search for 'Programmers'
I'm working with a binary structure, the goal of which is to index the significance of specific bits for any character encoding so that we may trigger events while doing specific checks against the profile. Each character encoding scheme has an associated system record. This record's leading value… >>> More
Determining default character set of platform in Java

as seen on Stack Overflow - Search for 'Stack Overflow'
I am programming in Java I have the code as: byte[] b = test.getBytes(); In the api it is specified that if we do not specify character encoding it takes the default platform character encoding. What is meant by "default platform character encoding" ? Does it mean the Java encoding or the OS… >>> More
Perl character encoding

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi People, I have an environment variable set in Windows as TEST=abc£ which uses Windows-1252 code page. Now when I run a perl program - 'test.pl', this environment value comes properly. When I call another perl code - 'test2.pl' from 'test1.pl' either by system(..) or Win32::process(..), the environment… >>> More