ODAC 8.6.12 is truncating data

[isdt]

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.

[AlexP]

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.

[isdt]

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.

[AlexP]

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.

[isdt]

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.

[AlexP]

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.

[isdt]

Hi Alex,

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

Thanks.

[AlexP]

Hello,

We plan to release the new ODAC version next week.

[isdt]

Hi Alex,

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

Thanks.

[AlexP]

Hello,

ODAC 9.0.2 is already available at our website.