v.25.6New Feature

Add bech32Encode and bech32Decode

Official CH changelog text
Added bech32Encode and bech32Decode functions for working with Bitcoin's Bech algorithm (issue #40381). #80239 (George Larionov).
Added bech32Encode and bech32Decode functions to support encoding and decoding using the Bitcoin Bech32 format.

Why it matters

These new functions enable users to work directly with the Bech32 encoding used in Bitcoin addresses, facilitating data processing and integration involving Bitcoin Bech32 strings within ClickHouse queries.

How to use it

Use the bech32Encode function to encode data into Bech32 format and bech32Decode to decode Bech32 strings back to their original binary representation in your SQL queries.

Related resources

PreviousNext