Title: whats is best collation to store bitcoin WIF key and bitcoin address in mysql ? Post by: btctousd81 on September 01, 2017, 04:57:06 AM 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 Title: Re: whats is best collation to store bitcoin WIF key and bitcoin address in mysql ? Post by: elbandi on September 02, 2017, 05:41:47 PM you can decode base58 to hex, and store the hex as binary.
Title: Re: whats is best collation to store bitcoin WIF key and bitcoin address in mysql ? Post by: btctousd81 on September 02, 2017, 05:51:52 PM 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 Title: Re: whats is best collation to store bitcoin WIF key and bitcoin address in mysql ? Post by: elbandi on September 02, 2017, 06:01:45 PM 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 can store this hex (as binary) in mysql: https://dev.mysql.com/doc/refman/5.5/en/blob.html Title: Re: whats is best collation to store bitcoin WIF key and bitcoin address in mysql ? Post by: btctousd81 on September 02, 2017, 06:03:51 PM 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 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. |