-
April 22nd, 2009, 06:21 PM
#1
byte[] to Binary
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.
Last edited by Tealc; April 22nd, 2009 at 10:12 PM.
-
April 23rd, 2009, 03:49 AM
#2
Re: byte[] to Binary
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
Last edited by Alsvha; April 23rd, 2009 at 03:52 AM.
-
April 23rd, 2009, 11:09 AM
#3
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|