Best practices for efficiently storing md5 hashes in mysql Best practices for efficiently storing md5 hashes in mysql mysql mysql

Best practices for efficiently storing md5 hashes in mysql


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)