阅读背景:

作为哈希的主键是应该存储为BINARY还是CHAR(十六进制)?

来源:互联网 

Records are identified by 32 byte SHA-2 value. Using BINARY is more compact (8 bits per byte vs 4 bits per byte) but that is offset by the increased difficulty in using binary value in adhoc queries (troubleshooting, etc). I am leaning towards storing as hex strings in 64 byte CHAR field. Are there any other issues or concerns beyond the Records are identified by 32 byte SHA-2 value.




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: