NLS_LANG
581817Mar 31 2008 — edited Apr 2 2008Having great difficulty in returning an extended character (178) [b2] from an Oracle DB.
Cannot get the character to show anything other than � or ? in Sql Developer (V1.2.1.3213) or from tableadapter build in VS2008 (ultimate goal is to return data via a webservice [hence using the AS32UTF8 codepage]).
The database NLS_LANG is set to AMERICAN_AMERICA.US7ASCII
The client machine registry key for NLS_LANG is set to ENGLISH.UNITED KINGDOM.AS32UTF8 and has the windows region/langauage settings to UK
Using the latest version of drivers (11.1.0.6.20)
Set the NLS Parameters in Sql Developer and changed the encoding to X-ORACLE-AL32UTF8 but still cannot get it to show the extended character using the following statement
SELECT CHR(178)
FROM dual;
CHR(178)
--------
�
select * from nls_session_parameters
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE ENGLISH
NLS_TERRITORY UNITED KINGDOM
NLS_CURRENCY �
NLS_ISO_CURRENCY UNITED KINGDOM
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE ENGLISH
NLS_SORT BINARY
NLS_TIME_FORMAT HH24.MI.SSXFF
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH24.MI.SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY ?
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS CHAR
NLS_NCHAR_CONV_EXCP FALSE
I tried numerous different encodings and registry keys but to no avail. Can anyone recommend any other areas/settings I should be looking at?
Thanks in advance
Mac