Devart Forums

table:
create table ORDERIMAGEINFO
(
FAC_NO VARCHAR2(5) not null,
ORDER_NO VARCHAR2(20) not null,
IMAGE BLOB
)

sqlconnection: Devart Oracle Direct

sqlQuery: select * from ORDERIMAGEINFO
code:
ClientDataSet1.Edit;
ClientDataSet1IMAGE.LoadFromFile('c:\1.jpg');
ClientDataSet1.Post;

ClientDataSet1.ApplyUpdates(0);
when call ClientDataSet1.ApplyUpdates(0) wait long time get oracle EIhternalError?

but when change DevartOracleDirect to DevartOracle driver it's no problem, why? is DevartOracleDirect bug?

Please specify the character set of your database.

first i install dbExpress driver for Oracle 4.4.0.13 have this problem,
but when I upgrade to 4.4.0.15 it's work fine, not have this problem.
but in 4.4.0.15 have another problem
where i add a string field in delphi 2009 design time it's TStringField,
when i run this program get :Exception class EDatabaseError with message 'SQLDataSet1: Type mismatch for field 'ENAME', expecting: String actual: WideString'. Process Project1.exe (3988)

why?

To avoid the problem, you should add UseUnicode=True to the Params property of TSQLConnection before creating fields.

Plash wrote:To avoid the problem, you should add UseUnicode=True to the Params property of TSQLConnection before creating fields.

Thank you!