v.25.5New Feature
Add functions for encoding and decoding base32
Added functions for encoding and decoding base32. #79809 (Joanna Hulboj).
Why it matters
To provide native support for Base32 encoding and decoding, enabling users to efficiently convert data to and from Base32 format within ClickHouse queries. This solves the problem of handling Base32 without external tools or custom implementations, enhancing data processing capabilities.How to use it
Use the newly introduced functionsbase32Encode() and base32Decode() in your SQL queries to encode binary data into Base32 string format or decode Base32 strings back to binary data respectively. Example:SELECT base32Encode('ClickHouse'), base32Decode(base32Encode('ClickHouse'));