Nonstop Database, HiRDB Version 9 Installation and Design Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
(1) Design considerations
- If the BLOB type is to be used, you must create a user LOB RDAREA.
- BLOB data is stored at an 8-kilobyte boundary, giving BINARY-type data better storage efficiency. However, if there is large object data, such that the 8-kilobyte boundary can be ignored, there is not much difference.
(2) Specification
Specify the BLOB type as the data type for the column when you use the CREATE TABLE definition SQL statement.
The BLOB type cannot be used with the following items:
- Tables with the FIX attribute
- Index definitions
- Partitioning keys
All Rights Reserved. Copyright (C) 2012, 2015, Hitachi, Ltd.