v.22.10Improvement

Add tryBase58Decode function similar to tryBase64Decode

Add function tryBase58Decode, similar to the existing function tryBase64Decode. #41824 (Robert Schulze).
Introduces the tryBase58Decode function, providing a way to decode Base58-encoded strings similarly to the existing tryBase64Decode function in ClickHouse.

Why it matters

This feature addresses the need for decoding Base58-encoded data directly within ClickHouse queries, enabling users to handle Base58 encoding commonly used in cryptocurrencies and other applications without external preprocessing. It enhances ClickHouse's native support for various encoding formats, improving query flexibility and data processing capabilities.

How to use it

Use the function tryBase58Decode(string) in your SQL queries to decode a Base58-encoded string. It safely returns the decoded result or NULL if decoding fails, similar to tryBase64Decode. Example usage:

SELECT tryBase58Decode('your_base58_encoded_string') AS decoded_data
FROM your_table