Oracle Unicode Encoding

Oracle Unicode Encoding

Postby julius » Fri 14 Jul 2017 05:14

Request assistance please.
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


Field01 and Field02 are both NVARCHAR2 data types.
There are no errors, but the chinese characters are replaced with question mark (?).
When I try the same query above on
Oracle SQL Developer
, the table is updated correctly.

How could I properly store Unicode characters to Oracle using Devart ODBC driver.

Thank you.
julius
 
Posts: 1
Joined: Fri 14 Jul 2017 04:55

Re: Oracle Unicode Encoding

Postby MaximG » Fri 14 Jul 2017 14:16

Thank you for the information. We are investigating the issue and will inform you as soon as any results are available.
MaximG
Devart Team
 
Posts: 740
Joined: Mon 06 Jul 2015 11:34


Return to ODBC Drivers