Best practices for efficiently storing md5 hashes in mysql
md5, mysql, passwords
Solution
If the column is indexed and you know what you're doing, `BINARY(16)` for performance reasons.
Otherwise, `CHAR(32)` is fine. Make sure the column uses the ascii charset though. (`ascii_bin` for example)
Problem
Possible field types: ``` BINARY(16) CHAR(32) BIGINT + BIGINT ``` How do I decide which one to use?