Select CLOB data question..
Posted: Wed 26 Oct 2005 10:07
Orasession1 option
Net := True;
CharLength := 0;
Charset := '';
UseUnicode := True;
query : Select TestClob from testClobTable where Idx := '1'
(TestClob -> clob field)
SmartQuery1.Prepare;
SmartQuery1.Options.DeferredLobRead := False;
SmartQuery1.Options.CacheLobs := False;
SmartQuery1.Options.DeferredLobRead := True;
SmartQuery1.Execute;
SmartQuery1.GetLob('XML_ITEM_QUESTION').IsUnicode := True;
LobField1 := SmartQuery1.GetLob('XML_ITEM_QUESTION').AsString;
...
...
retrun data(LobField1) content:
#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0 ....
why?
Net := True;
CharLength := 0;
Charset := '';
UseUnicode := True;
query : Select TestClob from testClobTable where Idx := '1'
(TestClob -> clob field)
SmartQuery1.Prepare;
SmartQuery1.Options.DeferredLobRead := False;
SmartQuery1.Options.CacheLobs := False;
SmartQuery1.Options.DeferredLobRead := True;
SmartQuery1.Execute;
SmartQuery1.GetLob('XML_ITEM_QUESTION').IsUnicode := True;
LobField1 := SmartQuery1.GetLob('XML_ITEM_QUESTION').AsString;
...
...
retrun data(LobField1) content:
#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0 ....
why?