CompTIA Data+ DA0-002 (V2) Practice Question

BLOB is a binary large object designed to hold raw, variable-length bytes such as images, audio, or video. Because a BLOB column is not associated with any character set, the database stores the bit-stream exactly as supplied, meeting the requirement to avoid character-set conversion. CLOB and TEXT are character-oriented types; they expect data to be encoded as text, so storing binary video in them would either force conversion or fail, and they provide text functions that are irrelevant to video. VARCHAR(1024) is a variable-length string with a 1 KB limit in this definition; it is far too small for hundreds-of-megabyte files and would require base64 encoding, increasing size and violating the raw-bytes rule. Therefore, only the BLOB type satisfies both the binary-safety and size requirements.