v.22.7New Feature

Added base58 encoding/decoding functions

Added functions for base58 encoding/decoding. #38159 (Andrey Zvonov).
Added new functions to perform base58 encoding and decoding in ClickHouse.

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 like base58Encode(column), and to decode, use base58Decode(column). These functions work with string or binary inputs and outputs.