v.22.10Improvement
Add tryBase58Decode function similar to tryBase64Decode
Add functiontryBase58Decode, similar to the existing functiontryBase64Decode. #41824 (Robert Schulze).
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 functiontryBase58Decode(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