facing the problem in displaying the special characters

[rhandoo]

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
Rakesh

[kenobewan]

Maybe show us how you are writing this sentence to the db?

[r035198x]

Maybe show us how you are writing this sentence to the db?

Or rather the code that's displaying the values since the OP seems to suggest that the value is being stored correctly in the database.

[rhandoo]

Or rather the code that's displaying the values since the OP seems to suggest that the value is being stored correctly in the database.

Thanks for your reply

Value in DB
------------------
TONY ROBINSON`S CRIME AND PUNISHMENT

Code which gets the text from
----------------------------------------------
internal static string sql = @"select prottl.prottl_title_tex from prottl join ctr on prottl.ctr_key =ctr.ctr_key where ctr.ctr_contrt_num=:P_CONTRACT_NO";



public string getcontractTitle(Int64 contractNo) //43917
{

string contractTitle = "";
try
{


OracleCommand qgetTitle = new OracleCommand(sql, _oraConnection);

qgetTitle.CommandType = CommandType.Text;
qgetTitle.Parameters.Add(new OracleParameter("P_CONTRACT_NO", OracleType.Number)).Value = contractNo;
OracleDataReader reader = qgetTitle.ExecuteReader();

while (reader.Read())
{

contractTitle = reader["prottl_title_tex"].ToString();

}

}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
}
return (contractTitle);
}