Home » SQL & PL/SQL » SQL & PL/SQL » Not able to retrieve unicode characters on the client.
Not able to retrieve unicode characters on the client. [message #146695] Sat, 12 November 2005 07:33 Go to next message
acrao80
Messages: 1
Registered: November 2005
Junior Member
Hi
Using the UNISTR function I have inserted chinese and greek characters in my table.
When I try to retrieve chinese characters using my application (oracle client side in vc++7.0 .NET envioroment), I only see ???.This is even though I have installed all font and languages on my OS.
NOTE:I am able to retrieve all unicode characters using same Cstring variables in MS SQL.
Oracle 9.2 database settings are as follows
nls_database_parameters

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET US7ASCII
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.4.0

I am working on a windows XP machine and my NS_LANG settings
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\ ==== > NS_LANG AMERICAN_AMERICA.UTF8
Also i am not able retrieve and view the unicode data using any utility like sqlplus.
I have gone through a lot of sites and documentation but I have tried a lot many settings but unsuccessful please help me.
Re: Not able to retrieve unicode characters on the client. [message #192146 is a reply to message #146695] Mon, 11 September 2006 04:25 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Try there settings
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET UTF8
But these setting can increase the size of Database.

Sandy
Re: Not able to retrieve unicode characters on the client. [message #192298 is a reply to message #192146] Mon, 11 September 2006 13:06 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Your database characterset is US7ASCII, so unless you are using "N" datatypes like NVARCHAR2, your data won't be stored in AL16UTF16 (NLS_NCHAR_CHARACTERSET). Do a dump on your data to see if the bytes stored are correct (select dump(mycol), dump(mycol, 1010), dump(mycol, 1016) from...)

Consider re-creating your database using UTF8 characterset and then set your client NLS settings to the appropriate values.
Previous Topic: Autofit is not working while transfering data to excel from 10gdatabase
Next Topic: Question about getting the Top N or Bottom N of a dataset
Goto Forum:
  


Current Time: Wed Dec 07 18:23:11 CST 2016

Total time taken to generate the page: 0.23813 seconds