Data Type Considerations for Change Data Capture
All base column types are supported by change data capture. The following table lists the behavior and limitations for several column types:
Type of Column
Changes Captured in Change Tables
Does not support capturing changes when using a columnset.
Changes to computed columns are not tracked. The column will appear in the change table with the appropriate type, but will have a value of NULL.
Changes to individual XML elements are not tracked.
The data type in the change table is converted to binary.
BLOB data types
The previous image of the BLOB column is stored only if the column itself is changed.