Re: [Firebird-devel] HASH function (CORE-4436)

[Leyne, S. <Se...@br...>]

> On 18/07/2017 16:32, Dmitry Yemanov wrote:
> >
> >
> >> When two parameters are passed, it will return a VARCHAR(64)
> >> CHARACTER SET OCTETS. That's sufficient for a SHA-256, for example.
> >
> > Would it make sense to reserve more bytes, 256 or 1024 octets for
> > example? Just to avoid extending the result every five years...
> 
> Ok for me, I believe 256 would be good then, as very large column is difficult
> to read in ISQL.

If we are going to support common HASH functions then we need to support all currently/commonly available.

In which case a length of at least 512 bits/128 bytes (for SHA-512 and SHA3-512) is required -- difficulty reading is the last thing that should be of concern.


Sean