MySQL Forums
Forum List  »  PHP

Re: Password Data type in mysql
Posted by: Rick James
Date: April 30, 2012 12:46AM

When storing a 256-bit value, use BINARY(32) if it is in binary, or BINARY(64) if it is in hex.

See Rick's RoTs, Datatype section:
Quote

Since GUID, UUID, MD5, and SHA1 are fixed length, VAR is not needed.
If they are in hex, don't bother with utf8; use BINARY or CHAR CHARSET ascii.
-- http://mysql.rjweb.org/doc.php/ricksrots

Options: ReplyQuote


Subject
Written By
Posted
Re: Password Data type in mysql
April 30, 2012 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.