How to get character (ascii value = 146) from database?
123042Dec 9 2003 — edited Dec 9 2003Dear all,
I have problem getting the character with ascii value 146 from an Oracle 9.2 db with NLS_CHARACTERSET = WE8ISO8859P1. The character is stored in a VARCHAR2 field.
I cannot get the character correctly via ODP.Net even though I have set the NLS_LANG value equals AMERICAN_AMERICA.WE8ISO8859P1 in the client machine. I have tried setting UTF8 also but still failed.
Could anyone please offer help on how to get that character correctly?