Skip to Main Content
Forums

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!

ODP.NET charakterset problem

444826Jun 2 2005 — edited Sep 27 2006
Hi,
I have a problem using ODP.Net 9.2.0.1.0 accessing an Oracle database that uses EE8ISO8859P2 characterset.
NET application, we have developed do not display some characters correctly.We have not problem with this using OleDbConnection.Here is the output from test app.:
using OleDb: ľ-š-č-ť-ž-ý-á-í-é-ú-ň-Ľ-Š-Č-Ť-Ž-Ý-Í-É-Ú-Ň
using ODP.NET:ž-?-č-?-?-ý-á-í-é-ú-ň-ź-?-Č-?-?-Ý-Í-É-Ú-Ň
But the results using Oledb are the same (incorrect) when I unset NLS_LANG variable.It looks like ODP.NET don't use NLS_LANG variable?
Below is the environment I use.
server:
Linux + Oracle9i 9.2.0.4
NLS_CHARACTERSET=EE8ISO8859P2
NLS_NCHAR_CHARACTERSET=AL16UTF16
client:
WinXP + Oracle9i Client 9.2.0.1,ODP.NET 9.2.0.4.01,MS .NET 1.1
NLS_LANG=AMERICAN.AMERICA.EE8ISO8859P2

Any suggestions or help are appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2006
Added on Jun 2 2005
#odp-net
2 comments
945 views