TON address functions

Smart contract addresses on the TON blockchain are composed of two key components:

1. Workchain Identifier. A signed 8-bit number that identifies the workchain. Currently, only the masterchain (workchain_id = -1) and occasionally the basic workchain (workchain_id = 0) are active on the TON blockchain.
2. Account Identifier. A 256-bit number unique to each account within a workchain.

There are two different representation of contract addresses on TON blockchain:

• Raw addresses: Original full representation of smart contract addresses. Raw smart contract addresses consist of a workchain ID and account ID and are displayed in the following format: <decimal workchain_id>:<64 hexadecimal digits with account_id>. Example: -1:fcb91a3a3816d0f7b8c2c76108b8a9bc5a6b7a55bd79f8ab101c52db29232260.
• User-friendly addresses: An enhanced version of raw address designed to improve security and usability. User-friendly addresses were developed to secure and simplify the experience for TON users who share addresses on the internet (for example, on public messaging platforms or via their email service providers), as well as in the real world. User-friendly addresses are made up of 36 bytes in total.

We provide functions to translate between the two formats.

Functions

ton_address_raw_to_user_friendly()

ton_address_raw_to_user_friendly(varchar, boolean) → varchar

Converts a raw address to its user-friendly equivalent. The second argument is a boolean flag that specifies whether the bounceable flag is enabled (true) or disabled (false). If omitted, the bounceable flag defaults to true.

SELECT 
    ton_address_raw_to_user_friendly('0:ca6e321c7cce9ecedf0a8ca2492ec8592494aa5fb5ce0387dff96ef6af982a3e', true)
-- results 'EQDKbjIcfM6ezt8KjKJJLshZJJSqX7XOA4ff-W72r5gqPrHF'

ton_address_user_friendly_to_raw()

ton_address_user_friendly_to_raw(varchar) → varchar

Converts a user-friendly address back to its raw representation.

SELECT 
    ton_address_user_friendly_to_raw('0QDKbjIcfM6ezt8KjKJJLshZJJSqX7XOA4ff-W72r5gqPleK')
-- results '0:ca6e321c7cce9ecedf0a8ca2492ec8592494aa5fb5ce0387dff96ef6af982a3e'