NVARCHAR2 field value truncated

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
robymes
Posts: 29
Joined: Tue 09 Sep 2008 09:46

NVARCHAR2 field value truncated

Post by robymes » Mon 29 Dec 2008 11:02

hello,
I'm using Entity Framework, I have an application which worked well with old 4.7x version. Now I upgraded to newest 5.0 version and suddenly all the NVARCHAR2 database fields have a problem: the value is truncated when queried with Entity Framework.
If I change the field type to VARCHAR2 it works.
what has happened between version 4.7x and version 5.0?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 29 Dec 2008 15:50

Please specify the exact version (x.xx.xx) of dotConnect for Oracle you are using.
I have checked the 5.00.16 version. There is no truncation with the NVARCHAR2 fields (the values are stored in the database with original spaces in the end of string).

robymes
Posts: 29
Joined: Tue 09 Sep 2008 09:46

Post by robymes » Mon 29 Dec 2008 16:30

my version is 5.0.16.0 (as I just read from GAC), and I have problem in reading values from NVARCHAR2 fields.
I just disinstalled 4.73 version, installed 5.00.16, changed the Provider string to "Devart.Data.Oracle", build and run the application. No other changes at all.
all the NVARCHAR2 field values (in various classes) are truncated.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 30 Dec 2008 14:29

Thank you for the report, we have reproduced this Direct mode problem. We will investigate the reasons and notify you about the results right after the holidays.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 05 Jan 2009 14:32

The problem is fixed, look forward to the next build.

Post Reply