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.