BLOB/CLOB command line support
The hcidbprotocoltest testing tool retrieves the BLOB/CLOB content and saves it into a temp file, located at:
- current_location/temp, when running hcidbprotocoltest from the command line.
- $HCIROOT/temp, when running hcidbprotocoltest in the Testing Tool GUI.
The CLOB temp file uses ".clb" as the file extension. This file is UTF-8 encoded.
The BLOB temp file uses ".blb" as the file extension.
The temp file name is composed of these sections:
- A constant beginning with
dbpcache
. - An intermediate with
sha256sum
of the file. - An extension.
The Testing Tool retains only one cached temp file (local) if the database table records have the same content for the CLOB/BLOB column.
hcidbschematest lists the CLOB/BLOB based on the message's matched fields.
In most instances, the CLOB field begins with
"3A45E466D51049A11BCC3E52AD22216DE2E9046C4E98EA7545B60B8617487DE2"
followed by a full file path.
The BLOB field begins with
"92C674350DE16494C901601E1504E96627757E61684CDF28B9A3E2847DE687A
",
followed by a full file path.