whats is best collation to store bitcoin WIF key and bitcoin address in mysql ?

[btctousd81]

i need to know which collation in mysql is best to keep the size as low as possible so that the db size will be smaller and queries will be quicker.

i am currently using utf8_unicode_ci, but i read ascii stores more data in less space.

i want to lower db size so it can be fit in RAM.

so what are you guys using ?


thanks

[1713530240]

1713530240

[1713530240]

1713530240

[elbandi]

you can decode base58 to hex, and store the hex as binary.

[btctousd81]

you can decode base58 to hex, and store the hex as binary.

i still dont get it., what do you mean by decode base58 to hex ?

do i have tp decode both WIF and bitcoin address ? and store as binary ?

what charset should i use ?

can i later search directly by using bitcoin address ?


thanks

[elbandi]

you can decode base58 to hex, and store the hex as binary.

i still dont get it., what do you mean by decode base58 to hex ?

do i have tp decode both WIF and bitcoin address ? and store as binary ?

what charset should i use ?

can i later search directly by using bitcoin address ?


thanks

you have an address, like 1QCkaDkCDAtsxG9LrLDbPrSne7q3hM3qm3 decode base58, you get: 00FE83D76016CF60187F978ACECB3480086BDD6443A1B813CA
you can store this hex (as binary) in mysql: https://dev.mysql.com/doc/refman/5.5/en/blob.html

[btctousd81]

you can decode base58 to hex, and store the hex as binary.

i still dont get it., what do you mean by decode base58 to hex ?

do i have tp decode both WIF and bitcoin address ? and store as binary ?

what charset should i use ?

can i later search directly by using bitcoin address ?


thanks

you have an address, like 1QCkaDkCDAtsxG9LrLDbPrSne7q3hM3qm3 decode base58, you get: 00FE83D76016CF60187F978ACECB3480086BDD6443A1B813CA
you can store this hex (as binary) in mysql: https://dev.mysql.com/doc/refman/5.5/en/blob.html

okie, this is new., i am looking in to it,

thanks

looks like i can then decode WIF key too.