Devart Forums

Posted: **Thu 13 Jun 2013 19:09**

Hello,
I am using ODAC library version 8.6.12 to connect to oracle with Delphi 6, I have a nvarchar(32) column in Oracle table and as you can see it has a maximum of 32 characters so let's say I have a value in this field like
"123456789-123456789-123456789-12"

The issue appears on some customers PCs where the result will be truncated to 16 characters, so the following code will return a string with 16 characters "123456789-123456":

Code: Select all

var MyID: string;
begin 
  MyID:= OraQuery.Field[0].AsString;
  //MyID must be "123456789-123456789-123456789-12"
  // -->>but the result is MyID = "123456789-123456"  only 16 characters 
end;

This is strange because the code used to work using the old ODAC (6.1.0) on all computers, only using the new ODAC 8.6.12 on some customer computers it doesn't work -on my computer it works fine-!

Questions:
1. Why am I having this issue?
2. I think that there is a bug fix in ODAC 9.0 does that fix my issue?
3. is this issue related to windows 7?

Thank you.

Posted: **Fri 14 Jun 2013 08:53**

Hello,

We have already fixed the problem, the fix will be included to the next version of ODAC, that will be released in the beginning of the next month.

Posted: **Mon 17 Jun 2013 11:09**

Thank you for the reply,
would you please give us some information about the bug, the customer is using windows 7 with Oracle 10g and UTF-8 database, is the bug related to windows 7?
or it is related to Oracle 10g in UTF-8 database?

Your help will be appreciated, thank you for your consideration.

Posted: **Tue 25 Jun 2013 09:08**

Hello,

That problem was due to the specificity of the old Oracle protocol when working with Unicode, that we used in the Direct mode. We have supported the new protocol, that solves the problem.

Posted: **Wed 26 Jun 2013 09:25**

We could not reproduce this issue in our local lab. Would you please tell us all the required settings (on client and server), versions of OS, version or Oracle, variables,...etc. in order to reproduce the problem?
This is important to verify the fix once we get the fixed version from you before sending it to our customer.

Thank you.

Posted: **Tue 02 Jul 2013 09:10**

Hello,

This problem occurred in case when the size of character fields is set not in Byte, but in char on a Unicode database with floating character length.

Posted: **Wed 03 Jul 2013 17:03**

Hi Alex,

Any specific date for the ODAC release which contains the fix to this issue?

Thanks.

Posted: **Thu 04 Jul 2013 07:45**

Hello,

We plan to release the new ODAC version next week.

Posted: **Sun 14 Jul 2013 15:46**

Hi Alex,

We are still waiting for the new ODAC release, do you have a specific release date?

Thanks.

Posted: **Tue 16 Jul 2013 06:33**

Hello,

ODAC 9.0.2 is already available at our website.

Devart Forums

ODAC 8.6.12 is truncating data

ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data

Re: ODAC 8.6.12 is truncating data