Multibyte character (Chinese, Korean....) support problem
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)