Another fild values

Hi

Would it be possible to add more options and values ​​in the API Unnamed -Insert files into table, such as :
%fileextension%, %filemd5sum% and %filesha1sum% to read and store this informations?
I believe that would be of great help functions as well.

Thanx

As MD5 and SHA1 functions are natively supported by MySQL (but not by Delphi) I think it's easier to update a table afterwards, e.g. like this:

UPDATE mytable SET col_md5=MD5(col_contents), col_sha=SHA1(col_contents)

Hi Anse,
You saved my life!

When I posted about the md5sum and sha1sum, was exactly what we needed.
We have a photographic collection of approximately 2.5TB and more 4TB of historical documents in pdf format (Blob).

We believe that we have many duplicate files as we are changing some servers, updating versions and even lost some tables and now we are trying to put everything in order.

The use of md5 or sha1 and allows you to check if the hash is in duplicate.

Thank you very much.
Regards