| Not able to retrieve unicode characters on the client. [message #146695] |
Sat, 12 November 2005 07:33  |
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 #192298 is a reply to message #192146] |
Mon, 11 September 2006 13:06  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
