v.22.7New Feature
Added base58 encoding/decoding functions
Added functions for base58 encoding/decoding. #38159 (Andrey Zvonov).
Why it matters
Base58 encoding is widely used for creating compact, human-readable representations of binary data, commonly in cryptocurrency addresses and other applications where avoiding ambiguous characters is crucial. This feature allows users to encode and decode data to and from base58 directly within ClickHouse queries, simplifying data processing workflows involving such formats.How to use it
Use the newly introduced functions for base58 encoding and decoding directly in your SQL queries. For example, to encode data to base58, apply the function likebase58Encode(column), and to decode, use base58Decode(column). These functions work with string or binary inputs and outputs.