Skip to content

Instantly share code, notes, and snippets.

@deoxxa
Created March 19, 2011 21:48
Show Gist options
  • Save deoxxa/877843 to your computer and use it in GitHub Desktop.
Save deoxxa/877843 to your computer and use it in GitHub Desktop.
mysql> select HEX(hash), LENGTH(hash), CHAR_LENGTH(hash) FROM files LIMIT 5;
+------------------------------------------------------------------------+-------------------+------------------------+
| HEX(hash) | LENGTH(hash) | CHAR_LENGTH(hash) |
+------------------------------------------------------------------------+-------------------+------------------------+
| 00001125C59306E280B94D29E280BA6C3DC2A17E7BC3A4C2A8CB86C38467 | 30 | 20 |
| 0000C29033E28093C3842548C39F41C39BC2B3C2B4E280A1C381C3A517C39C2BE280A1 | 35 | 20 |
| 0000C2A4C3A0C3B806C2ADC383385929C3832E1EC2BD593FC5B84F60 | 28 | 20 |
| 0000C2A51A45071926C393C394C39DCB9C26087FE280997B2B534F | 27 | 20 |
| 00011EC2ADC385E28094C38806C2BBC2B0C593E28099C2B5521125C2B4C2BC150B | 33 | 20 |
+------------------------------------------------------------------------+-------------------+------------------------+
5 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment