-2

What are the possible lengths for addresses and seeds?

As this is important for designing a database to store these values.

lulalala
  • 415
  • 2
  • 8

1 Answers1

2

The address are usually 90 characters long, which includes 9 characters of checksum. (meaning char(90) column is a good fit)

(but api does accept 81 character address which are without checksum in various functions)

The seed is 81 characters long, but sometimes it can be less. However for addresses less than 81 characters long, it will need to be padded with '9'. So we should still use char(81).

lulalala
  • 415
  • 2
  • 8
  • 1
    As the lengths are constant, I'd use char(90) or char(81) instead. – mihi Jan 13 '18 at 16:01
  • for postgres, there is no performance advantage to using char over varchar. https://www.postgresql.org/docs/9.0/static/datatype-character.html – theoretical Jan 13 '18 at 18:51
  • I didn't suggest it for performance advantages but because on most DBMS they are smaller (if filled completely) as there is no need to store the length (don't know about Postgres though). – mihi Jan 13 '18 at 23:10
  • @mihi I recall that seed can be less than 81 characters, so char will not do. I guess address is always 90 characters though? – lulalala Jan 14 '18 at 14:36
  • 2
    It is possible to enter less than 81 characters for the seed in the current reference wallet implementation (the wallet will pad the seed with 9 at the end). When using the API, the seed has to be exactly 81 characters long. – mihi Jan 14 '18 at 17:20