DB2 BLOB Knowledge centre link
From the IBM Knowledge centre guide :
- BLOB or BINARY LARGE OBJECT(integer [K | M | G])
- For a binary large object string of the specified
maximum length in bytes.
The length may be in the range of 1 byte
to 2 147 483 647 bytes.
If integer by
itself is specified, that is the maximum length.
If integer
K (in either upper- or lowercase) is specified, the
maximum length is 1 024 times integer.
The maximum value for integer is 2 097 152.
If integer
M is specified, the maximum length is 1 048 576
times integer. The maximum value for integer is
2 048.
If integer G is specified,
the maximum length is 1 073 741 824 times integer.
The maximum value for integer is 2.
If
a multiple of K, M or G that calculates out to 2 147 483 648
is specified, the actual value used is 2 147 483 647
(or 2 gigabytes minus 1 byte), which is the maximum length for a LOB
column.
If the length specification is omitted, a length of
1 048 576 (1 megabyte) is assumed.
Any number
of spaces is allowed between the integer and K, M, or G, and a space
is not required. For example, all of the following are valid:
BLOB(50K) BLOB(50 K) BLOB (50 K)