Which function better to use- faster, less collisions:
md5('somelonglonglongstring')
or
encode(digest('somelonglonglongstring', 'sha256'), 'hex')
What data type to use for sha256? varchar(64)? Or any other function is better?
Asked
Active
Viewed 180 times
1
Takito Isumoro
- 174
- 1
- 11
-
1[This SO question](https://stackoverflow.com/questions/14139727/sha-256-or-md5-for-file-integrity) which compares MD5 and SHA seems to be at least relevant to your question. – Tim Biegeleisen Feb 25 '19 at 11:25