Tuesday, April 17, 2007

DB2: How does DB2 store NULL physically?

as an extra-byte prefix to the column value.
The NULL prefix is Hex '00' if value other than NULL is present in the column.
The NULL prefix is Hex 'FF' if the column has NULL value.

No comments: