TO_BLOB

TO_BLOB( raw_value )

CREATE TABLE tbl_raw (COL_RAW RAW(16));

-- Insert a row of data into the table, where the value of the `COL_RAW` column is `0ABC`.
-- In the `RAW` type, a string is interpreted as hexadecimal data.
-- Therefore, the `'0ABC'` value here is stored in the binary format and occupies two bytes: 0A (hexadecimal format) and BC (hexadecimal format).
INSERT INTO tbl_raw (COL_RAW) VALUES ('0ABC');

-- Insert another row of data, where the value of the `COL_RAW` column is `0123456789ABCDEF`. The value is converted and stored as binary data of eight bytes.
-- The eight binary bytes are: 01, 23, 45, 67, 89, AB, CD, and EF.
INSERT INTO tbl_raw (COL_RAW) VALUES ('0123456789ABCDEF');

obclient> SELECT COL_RAW,LENGTHB(COL_RAW) "LENGTHB_RAW",LENGTHB(TO_BLOB(COL_RAW)) "LENGTHB_BLOB"
          FROM tbl_raw;
+------------------+-------------+--------------+
| COL_RAW          | LENGTHB_RAW | LENGTHB_BLOB |
+------------------+-------------+--------------+
| 0ABC             |           4 |            2 |
| 0123456789ABCDEF |          16 |            8 |
+------------------+-------------+--------------+
2 rows in set