v.20.10New Feature
Added RawBLOB Format for Unescaped Single Value Input/Output
Added format RawBLOB. It is intended for input or output a single value without any escaping and delimiters. This closes #15349. #15364 (alexey-milovidov).Why it matters
TheRawBLOB format addresses the need to handle raw binary large objects directly, enabling users to transfer single values in their exact binary form without any additional formatting, escaping, or delimiters. This simplifies processing and improves compatibility when working with raw binary data.How to use it
Use theRawBLOB format by specifying it in input or output operations where raw binary data transfer is required, for example, in INSERT or SELECT statements with the format clause:SELECT * FROM table FORMAT RawBLOB;or
INSERT INTO table FORMAT RawBLOB
<binary_data>