eugene y eugene y - 6 months ago 14
MySQL Question

Best practices for efficiently storing md5 hashes in mysql

Possible field types:

BINARY(16)
CHAR(32)
BIGINT + BIGINT


How do I decide which one to use?

Answer

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)

Comments