eugene y eugene y - 2 years ago 129
MySQL Question

Best practices for efficiently storing md5 hashes in mysql

Possible field types:


How do I decide which one to use?

Answer Source

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)

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download