Page 1 of 1
TOraLoader and BLOB
Posted: Wed 15 Aug 2007 12:30
by eml79
Can I use TOraLoader if table have blob column?
Blob store binary data (not clob!). Size blob column unknown or very big (few GB).
Posted: Thu 16 Aug 2007 08:20
by Plash
The TOraLoader component can be used for tables with BLOB column. But you should set the column value as string. So it is hardly to use the TOraLoader component for BLOB column with a binary data.
Posted: Fri 17 Aug 2007 07:55
by eml79
Plash wrote:The TOraLoader component can be used for tables with BLOB column. But you should set the column value as string. So it is hardly to use the TOraLoader component for BLOB column with a binary data.
String column required set maximum size. If I set size 10Gb it is not problem for TOraLoader?
Also if string will contain 0x00 byte - it is will truncate in TOraLoader or not?
Posted: Fri 17 Aug 2007 12:56
by Plash
You can set the Size property for the column maximum to 30000. If you load bigger BLOBs, data will be truncated.
A string can contain #0 and any other characters. This will not cause any problems.