TOraLoader and BLOB

eml79 · Post by **eml79** » Wed 15 Aug 2007 12:30

Can I use TOraLoader if table have blob column?
Blob store binary data (not clob!). Size blob column unknown or very big (few GB).

Plash · Post by **Plash** » Thu 16 Aug 2007 08:20

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.

eml79 · Post by **eml79** » Fri 17 Aug 2007 07:55

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?

Plash · Post by **Plash** » Fri 17 Aug 2007 12:56

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.