MySQL Forums :: PHP :: Password Data type in mysql
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:
See Rick's RoTs, Datatype section:
-- http://mysql.rjweb.org/doc.php/ricksrotsQuote
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.
| 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.
© 2013, Oracle Corporation and/or its affiliates