Hi! We have HASH function that returns a 64 bit integer. The algorithm is bad and the result too small for a hash.
I propose to extend the same function with a second parameter with the algorithm name. When only one parameter is passed, things works as now. When two parameters are passed, it will return a VARCHAR(64) CHARACTER SET OCTETS. That's sufficient for a SHA-256, for example. We implement (preferably getting code with compatible license or public domain - like was done for SHA-1 used in authentication - instead of use a bloated library) some algorithms (MD5, some useful SHA-*). No need for "hash plugins" for now. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel