I'm trying to store a bunch of 512-bit SHA-2 hashes into a MySQL table. In an effort to save space, I'm looking to store them in binary form, instead of a string of hex digits. I'm also using ORM so this will inflate them to any object / structure I choose.
I know I could split them up using eight "BIGNIT" columns but that's too time consuming. I also thought of putting them in a single "BLOB" column but I heard they're slow to access. Could anyone offer some wisdom on this? How about "binary(64)?"