Oracle Unicode Encoding
I am using Oracle 11g Enterprise server and my development platform is VB.net version 10, Windows 7 (x64) O/S.
Using Devart ODBC driver for Oracle I am updating my data table with the query below:
Code: Select all
UPDATE MyDataTable SET Field01= N'n''e''w在当今这个电', Field02= N'test在当今这个电' WHERE Id=124
There are no errors, but the chinese characters are replaced with question mark (?).
When I try the same query above on
, the table is updated correctly.Oracle SQL Developer
How could I properly store Unicode characters to Oracle using Devart ODBC driver.