v.21.8New Feature

Add bin/unbin functions

Add bin/unbin functions. #25609 (zhaoyu).
Added new functions bin and unbin to ClickHouse for binary data encoding and decoding.

Why it matters

These functions provide a straightforward way to convert data to and from a binary representation, enabling easier manipulation and storage of binary formats within ClickHouse.

How to use it

Use the bin function to convert input data into its binary form, and use unbin to decode binary data back to its original format. They can be used in SQL queries as functions applied to column data or literals.