C#

George_George wrote:

MD5 hashing returns byte[] other than numeric value in C#. Please feel free to correct me if I am wrong.

Public Shared Function GetMD5Encrypted(ByVal input As String) As String
        Dim md5hasher As MD5CryptoServiceProvider = New MD5CryptoServiceProvider()
        Dim hashedbytes() As Byte
        Dim encoder As New UTF8Encoding()

        hashedbytes = md5hasher.ComputeHash(encoder.GetBytes(input.ToCharArray()))
        Dim hashedstring As String = Nothing
        For Each i As Integer In hashedbytes
            hashedstring = hashedstring + i.ToString
        Next
        Return hashedstring
    End Function

George_George wrote:

"you could just make the sum off the bytes" -- interested in this. Any more details or pseudo code?

'the hashed string
String Hash="1564897548846357815";
Char c ;
Int result;
for each c in hash
   if isnumeric(c) then
       result = result + c
   else
       'do something to convert the char into an int
   end if
next

George_George wrote:

but result in the form of an int.

string a = "Input String";

MD5 crypto = MD5.Create();
byte[] rawHash = crypto.ComputeHash(UTF32Encoding.Default.GetBytes(a));
Guid guid = new Guid(rawHash);
int hash = guid.GetHashCode();

string a = "Input String";

MD5 crypto = MD5.Create();
byte[] rawHash = crypto.ComputeHash(UTF32Encoding.Default.GetBytes(a));
Guid guid = new Guid(rawHash);

int hash = 0;

for (int i=0; i<16; i+=4)
{
    hash ^= (rawGuid[i] << 24) | (rawGuid[i+1] << 16) | (rawGuid[i+2] << 8) | rawGuid[i+3];
}

return hash;

<br />
 IF NOT EXISTS (SELECT COLUMN_NAME FROM syscolumns WHERE COLUMN_NAME = 'MyColumn') THEN<br />
   ALTER TABLE ADD COLUMN MyColumn varchar(256) NULL;<br />
 END IF<br />