Options - LOB Options

How to show LOBs

With the default option (Display), AQT will try to display the value of BLOB/CLOB columns in the same way that other columns are displayed.

This may not give useful results if the column contains hex data or is very large. In this case, the option Send to Files provides a better mechanism for displaying LOB columns. This issue is described in more detail here.

You can also select what column-types this is done for: BLOBs, CLOBs and LONG VARCHAR:

• BLOBs means
  • BLOB (DB2/Oracle)
  • IMAGE (Sybase, SQL Server)
  • LONG VARBINARY (Sybase, SQL Server)
• CLOBs means CLOB (DB2)
• LONG VARCHAR means
  • LONG VARCHAR (DB2)
  • CLOB and LONG (Oracle)
  • TEXT and NTEXT (Sybase, SQL Server)
  • MEMO (Access)

Exclude LOBs when displaying tables

When this option is specified, AQT will not display any LOB values.

This can be useful if your tables contain LOB data and you aren't interesting in seeing their values (retrieving them can be time consuming).

Unicode

If you have enabled Unicode, AQT will write all CLOBs and Long Varchars values as unicode files. If you don't want your files in this format, you should disable Unicode (see Options > Unicode Options).