Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get character (ascii value = 146) from database?

123042Dec 9 2003 — edited Dec 9 2003
Dear 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2004
Added on Dec 9 2003
3 comments
2,295 views