Mysql Binary data type

Question

So my binary is: 0011010101100100001101000011000100110100001100000011001001100001011000100110001100110100011000100011001001100001001101110011011001100010001110010011011100110001001110010110010000111001001100010011000100110000001100010011011101100011001101010011100100110010

Md5: 5d41402abc4b2a76b9719d911017c592

Password: hello

I know the datatype is BINARY in mysql but what size do i need to make it? what do i fill in for the x?

BINARY(x)

Community · Accepted Answer · 2017-05-23 11:58:05Z

1

According to this, you can predict the size of a md5.

If you don't want to, it seems like VARBINARY type is what you're looking for.

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Sep 8, 2014 at 8:10

bemug

1,8142 gold badges13 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user4014674 Over a year ago

According to this en.wikipedia.org/wiki/MD5 and what you linked me to, you can predict the size of a md5 hash. an md5 hash is always a 32 character string. and no, i want to store my Binary as a Binary in MYSQL.

bemug Over a year ago

Ok I really missunderstood your question. Sorry about that, Richard Grant has the answer you're looking for.

logicBV · Accepted Answer · 2014-09-08 09:55:21Z

1

According to the MANUAL:

[...] the length for BINARY and VARBINARY is a length in bytes rather than in characters.

answered Sep 8, 2014 at 9:55

logicBV

231 silver badge7 bronze badges

Collectives™ on Stack Overflow

Mysql Binary data type

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related