0
, O
, I
, and l
to avoid confusion between similar-looking letters and numbers.
You can use the from_base58
function to convert a Base58-encoded string to a VARBINARY
value. For example, the following query converts the Base58-encoded string 3DZBMRwnSU8f
to a VARBINARY
value:
VARBINARY
values, we can use the bytearray_to_bigint
function to convert the VARBINARY
value to a BIGINT
value. However, we need to consider more things:
VARBINARY
value does not only contain the data we want to convert to a BIGINT
value. It also contains a discriminator that indicates which function of a solana program was called. We need to remove this discriminator before we can convert the VARBINARY
value to a BIGINT
value. We do this by using the bytearray_substring
function.
VARBINARY
value to a BIGINT
value. We do this by using the bytearray_reverse
function.
from_base58(varchar)
→ varbinary
Converts a Base58-encoded string to a VARBINARY
value.
to_base58(varbinary)
→ varchar
Converts a VARBINARY
value to a Base58-encoded string.