Originally Posted by Arcticwarrio
SHA1 produces a 40 character string.
Then why is the code shown above outputting a string that is 42 characters long?!
P.S. It appears that I chose a field of CHAR(44) because - as you mention above - SHA1() should give me a FIlename that is 40 character long, so when I add on a file extension (e.g. ".gif") it requires an extra 4 characters.