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!

I receive chrs 176 & 194 at the .NET end when selecting chr 176 fr Oracle??

441770Mar 6 2006 — edited Mar 8 2006

Howdy! :-)

I have been struggling with a problem for a while now, and it is that when I select a record containing '°' (chr 176 / hex B0) from the database I get 'Â°' (chr 176 AND chr 194) at the .NET end. And not only that, when I select a large set of data and convert it to XMLtype by using XMLELEMENT and XMLAGG it seems to screw up some tag that's coming a couple of tags after the actual record containing the '°'.

When I select the same character using SQL plus at the receiving server I get the correct results. No error codes are received.

I would be grateful for any help or suggestions on this peculiar problem.

Thanks in advance!
/Tony

Platform:
.NET Framwork: 1.1
Oracle DB server: 9.2.Oracle9i Enterprise Edition Release 9.2.0.6.0
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16
Oracle client: 10.1.0.2.0
NLS_LANG: SWEDISH_SWEDEN.W8EMSWIN1252
ODP.NET: Oracle Data Provider for .NET (10.1.0.3.01)

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 5 2006

Added on Mar 6 2006

#odp-net

6 comments

991 views