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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Multibyte character (Chinese, Korean....) support problem

201530Feb 1 2005
I used OLE DB(C++) and JDBC(Java) in Oracle 8i server with no problem. I worked very well.
but using ADO.NET(C#), there are the critical problem in selecting and inserting multibyte character (Chinese,Korean.. so on)

Oracle 8i Server charset : US7ASCII
Client NLS_LANG : AMERICAN_AMERICA.US7ASCII

- SELECT multibyte column

SELECT DUMP(multibyte) FROM table;
DUMP(multibyte)
----------------------------------------------------
Typ=1 Len=8: 199,209,177,219,195,226,183,194

- value in OracleString

OracleString.Value = ������� (broken character 0xfffd)

I think Oracle Data Provider for .NET can handle only ASCII characters with setting charset US7ASCII.
How I can get multibyte characters through byte array as binary data? (not String)

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 1 2005
Added on Feb 1 2005
#odp-net
0 comments
405 views