Clob field with Oracle 8i in ODAC Direct Mode

[Eden0928]

My environment:
WinXP sp3, Delphi 5, ODAC 9.4.14 for Delphi 5

OraSession setting below:

Code: Select all

   OraSession1.Options.Net:=true;
   OraSession1.Options.Direct:=True;
   OraSession1.LoginPrompt:=false;
   OraSession1.ConnectString:= 'Direct=True;Server=’ + ServerIP + ’;Port=' + PORT +
   ';SID=' + SID  + ';
   User ID=' + UserID +';
   Password=' + PWD ;
   OraSession1.Server := ServerIP+ ':' + PORT + ':' + SID ;

and DataLanguage same Oracle in Object Inspector:


I load clob field content in TRichEdit.



Garbled in above, Correct in below.

Why?

[MaximG]

Unfortunately, we have discontinued support for Delphi 5 for a long time. The oldest supported IDE version is Delphi 6. Try to reproduce the issue on the latest ODAC version 9.6.22