Functions and Operators
SS58 functions
ss58 or substrate58 is an address encoding scheme that is commonly used in substrate-based chains. It is similar to Base58 encoding format, with some modifications.
Under basic ss58 encoding format an address can be encoded as:
base58encode ( concat ( <address-type>, <address>, <checksum> ) )
Functions
from_ss58()
from_ss58(varchar)
→ varbinary
Converts an ss58-encoded string to the corresponding VARBINARY
address.
SELECT
from_ss58('1qnJN7FViy3HZaxZK9tGAA71zxHSBeUweirKqCaox4t8GT7')
-- results in VARBINARY 0x2534454d30f8a028e42654d6b535e0651d1d026ddf115cef59ae1dd71bae074e
to_ss58()
to_ss58(varbinary, int)
→ varchar
Encodes an address of a specific network type into its ss58 VARCHAR
representation. For example:
Polkadot
has address type 0Kusama
has address type 2Generic Substrate
has address type 42
SELECT
to_ss58('0x2534454d30f8a028e42654d6b535e0651d1d026ddf115cef59ae1dd71bae074e', 2)
-- results 'DR6pMC4GJiVbgPtNNuw1xgxJyEsYYuXKXq7ZCVBjfFrh3V5'
Was this page helpful?