Skip to Main Content

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!

Can't save c# string to NVARCHAR2

GardasarSep 18 2019 — edited May 5 2020

Hi!

Please, help... we have two db:

DB1

DB2

NLS_RDBMS_VERSION

12.1.0.2.0

12.2.0.1.0

NLS_NCHAR_CHARACTERSET

AL16UTF16

AL16UTF16

NLS_CHARACTERSET

WE8ISO8859P1

AL32UTF8

When using Microsoft.EntityFrameworkCore 2.2.6 and Oracle.EntityFrameworkCore 2.19.30 when writing to NVARCHAR2 string with cyrilic (for example "АльбертAlbert") in DB1, encoding is broken and "¿" are written in the field ("¿¿¿¿¿¿¿Albert"), but with DB2 everything is fine.

This post has been answered by Alex Keh-Oracle on May 5 2020
Jump to Answer
Comments
Post Details
Added on Sep 18 2019
8 comments
1,397 views