Skip navigation links

MySQL Forums :: PHP :: Password Data type in mysql


Advanced Search

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
Password Data type in mysql Mohamed Elamin 04/19/2012 05:33AM
Re: Password Data type in mysql laptop alias 04/19/2012 06:33AM
Re: Password Data type in mysql Rick James 04/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.