<p>Most of the tables that hold addresses have separate columns for the raw address and the Bech32 encoding.</p>
<p>Maybe there are some hints here: <a href="https://github.com/IntersectMBO/cardano-db-sync/blob/master/doc/interesting-queries.md" rel="nofollow noreferrer">https://github.com/IntersectMBO/cardano-db-sync/blob/master/doc/interesting-queries.md</a></p>

CC BY-SA 4.0
2024-08-31T19:42:36.597Z
Thanks for the replay. Is it possible that this page isn't up to date? In their examples the table 'tx_out' containers an raw_address field, but not in the latest db_sync?
Rainer Zufall
CC BY-SA 4.0
2024-09-01T20:41:08.677Z
Some changes were made recently and some more have been proposed. See https://github.com/IntersectMBO/cardano-db-sync/issues/1835
Erik de Castro Lopo
CC BY-SA 4.0
2024-09-03T20:00:22.323Z
Thank youi for the hints! Getting there.
Rainer Zufall
CC BY-SA 4.0
2024-09-11T14:16:51.680Z
I switched to https://github.com/MeshJS/mesh which solves the problem.
Rainer Zufall
CC BY-SA 4.0
2024-08-26T21:35:41.260Z
2024-08-26T21:35:41.260Z
Erik de Castro Lopo
<p>I'm a bit lost. I've got the <a href="https://github.com/cardano-foundation/cardano-connect-with-wallet/tree/main" rel="nofollow noreferrer">https://github.com/cardano-foundation/cardano-connect-with-wallet/tree/main</a> working and can get the used addresses from a wallet. I would like to use those to query db-sync. There seems to be conversion problem as the library returns raw addresses (?!?) and in db-sync 'addr1...' style addresses are used.</p>
<p>Is there any way to convert them or use the raw addresses to query db-sync?</p>
<p>Thanks!</p>

<cardano-db-sync><cip30>
CIP-30 address format to addr1 style for db-sync
# CIP-30 address format to addr1 style for db-sync

(Asked by: username_0 on 2024-08-26)

I'm a bit lost. I've got the <https://github.com/cardano-foundation/cardano-connect-with-wallet/tree/main> working and can get the used addresses from a wallet. I would like to use those to query db-sync. There seems to be conversion problem as the library returns raw addresses (?!?) and in db-sync 'addr1...' style addresses are used.

Is there any way to convert them or use the raw addresses to query db-sync?

Thanks!

**Tags:** cardano-db-sync, cip30

---

## 1 answers

### Answer by username_1 on 2024-08-26. Score: 0 | Accepted answer

Most of the tables that hold addresses have separate columns for the raw address and the Bech32 encoding.

Maybe there are some hints here: <https://github.com/IntersectMBO/cardano-db-sync/blob/master/doc/interesting-queries.md>

> **Comments:**
> **username_0**: Thanks for the replay. Is it possible that this page isn't up to date? In their examples the table 'tx_out' containers an raw_address field, but not in the latest db_sync?  
> **username_1**: Some changes were made recently and some more have been proposed. See https://github.com/IntersectMBO/cardano-db-sync/issues/1835  
> **username_0**: Thank youi for the hints! Getting there.  
> **username_0**: I switched to https://github.com/MeshJS/mesh which solves the problem.  

---

