Click to See Complete Forum and Search --> : byte[] to Binary


Tealc
April 22nd, 2009, 07:21 PM
I have a byte[] in c# that holds a SHA512 hash. I want to store the byte[] in a binary field in my MySQL and also in my MS SQL databases. What size do I need to make the binary field so that it is the exact size to hold the hash? I think there are 512 bits in 64 bytes. But I am not sure how this converts to binary.

I need this correct so passwords don't get corrupted. I also don't want to waste space by making the field too big.

Thank You.

Alsvha
April 23rd, 2009, 04:49 AM
Edit: Misread your post.

If the Hash is 64 bytes, you should be able to use binary(64).
However if you are unsure, varbinary(max) doesn't waste "much" space, and doesn't save additional additional data :)

Tealc
April 23rd, 2009, 12:09 PM
Ok thanks I will try 64.