ftADT text display problem

jdorlon · Post by **jdorlon** » Mon 22 Jun 2009 20:48

Hello,

I have Delphi 2009, ODAC 6.70, Oracle 11g client and server. Database character set is AL32UTF8.

In my code I have OraCall.OCIUnicode := True, and
TOraSession.Options.UseUnicode = True.

I have the following table in my database:

Code: Select all

CREATE OR REPLACE type TEXT_MESSAGE as object
(
  text_len  int,
  text_vc   varchar2(4000),
  text_lob  clob
)
/

CREATE TABLE A_TEXT_MESSAGE
(
  COL1   NUMBER,
  MSG1   TEXT_MESSAGE,
  MSG2   TEXT_MESSAGE,
  ACLOB  CLOB
);

Insert into A_TEXT_MESSAGE
   (COL1, MSG1, MSG2, ACLOB)
 Values
   (1,
    "TEXT_MESSAGE"(1,'blah blah','aaaaaaaaaaaaaaaaaaaaaaaaaaaa'),
    "TEXT_MESSAGE"(12,'3blah blah','bbbbbbbbbbbbbbbbbbb'), 'qqqqqqqqqqqqqqq');
Insert into A_TEXT_MESSAGE
   (COL1, MSG1, MSG2, ACLOB)
 Values
   (2,
    "TEXT_MESSAGE"(2,'ablah blah','ccccccccccccccccccccccccc'),
    "TEXT_MESSAGE"(22,'3blah blah','dddddddddddddddddd'), 'wwwwwwwwwwwwwwwwwwwwwwwww');
Insert into A_TEXT_MESSAGE
   (COL1, MSG1, MSG2, ACLOB)
 Values
   (3,
    "TEXT_MESSAGE"(3,'bblah blah','eeeeeeeeeeeeeeeeeeeeeee'),
    "TEXT_MESSAGE"(32,'3blah blah','fffffffffffffffffffff'), 'eeeeeeeeeeeeeeeeee');

COMMIT;

Now, when I put 'select * from A_TEXT_MESSAGE' into a TSmartQuery, and drop a TDBEdit on the form for the MSG1 field, the data is not displayed properly for the clob inside the text_message field.

What I see for the first row looks like this:
(1, blah blah, 慡慡慡慡慡慡慡慡慡慡慡慡慡慡)

Is this a bug?

thanks,

-John

Plash · Post by **Plash** » Wed 24 Jun 2009 08:05

We have fixed this problem. The fix will be included in the next build of ODAC.

jdorlon · Post by **jdorlon** » Wed 24 Jun 2009 13:12

Great, thank you

jdorlon · Post by **jdorlon** » Fri 26 Jun 2009 15:04

I just installed 6.80.0.48, but I still see the problem. Is the fix included in this version?

Plash · Post by **Plash** » Tue 30 Jun 2009 06:51

Yes, the fix is included in ODAC 6.80.0.48. Please send to odac*devart*com a complete small sample that demonstrates the problem.

jdorlon · Post by **jdorlon** » Tue 30 Jun 2009 17:16

ok, I emailed a demo.