ftADT text display problem
Posted: 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:
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
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;
What I see for the first row looks like this:
(1, blah blah, 慡慡慡慡慡慡慡慡慡慡慡慡慡慡)
Is this a bug?
thanks,
-John