facing the problem in displaying the special characters in C#

Aug 6 2008 7:04 PM

Hi,

I am facing the problem in displaying the special characters like
( ` ) GRAVE ACCENT in C# windows Application.

I am using oracle as back end.
In oracle database table the string contain the above character is stored as
TONY ROBINSON`S CRIME AND PUNISHMENT in places in single code ( ‘ ) .

Oracle database has following settings in nls_database_parameters

1 NLS_NCHAR_CHARACTERSET AL16UTF16
2 NLS_LANGUAGE ENGLISH
3 NLS_TERRITORY UNITED KINGDOM
4 NLS_CURRENCY #
5 NLS_ISO_CURRENCY UNITED KINGDOM
6 NLS_NUMERIC_CHARACTERS .,
7 NLS_CHARACTERSET WE8ISO8859P1
8 NLS_CALENDAR GREGORIAN
9 NLS_DATE_FORMAT DD-MON-RR
10 NLS_DATE_LANGUAGE ENGLISH
11 NLS_SORT BINARY
12 NLS_TIME_FORMAT HH24.MI.SSXFF
13 NLS_TIMESTAMP_FORMAT DD-MON-RR HH24.MI.SSXFF
14 NLS_TIME_TZ_FORMAT HH24.MI.SSXFF TZR
15 NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH24.MI.SSXFF TZR
16 NLS_DUAL_CURRENCY ?
17 NLS_COMP BINARY
18 NLS_LENGTH_SEMANTICS BYTE
19 NLS_NCHAR_CONV_EXCP FALSE
20 NLS_RDBMS_VERSION 10.1.0.5.0

On client PC has following
• In Regedit "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\"
• Under key called - KEY_OraClient10g_homeX where X is a number.
• Value of "NLS_LANG" = "ENGLISH_UNITED KINGDOM.WE8ISO8859P1"
But still the c# windows application displays the text properly. The special character ( ` ) is displayed as square brackets

Can anyone please help & let me know the solution

thanks