My system is Linux (SUSE 10.1) and i try to retrive data from IBM DB2 database with ODBC connection (unixODBC).
I use TODBCconnecion and TSQLQuery. All the system work fine for all kind of data (i.e. blob), but with the clob data the result of query is incorrect, like:
"⃈…„?@ÅÕåññðð@`@Á™£‰ƒ–“–z@ôõñ ...."
I use for blob and clob:
"if self.SQLQuery1.Fields.Fields.IsBlob then
begin
. BlobField:=TBlobField(self.SQLQuery1.Fields.Fields);
. if not(BlobField.IsNull) then Result:=fb.Value; "
end;
Where is the (my) error?
Can you help me?