How to convert Existing Data into Hash Format(Base64Format)

If you want it in SQLServer level:

http://blog.falafel.com/t-sql-easy-base64-encoding-and-decoding/

https://www.mssqltips.com/sqlservertip/4037/storing-passwords-in-a-secure-way-in-a-sql-server-database/

In application level (C#):

Encode

public static string Base64Encode(string plainText) {

var plainTextBytes = System.Text.Encoding.UTF8.GetBytes(plainText);

return System.Convert.ToBase64String(plainTextBytes);

}

Decode

public static string Base64Decode(string base64EncodedData) {

var base64EncodedBytes = System.Convert.FromBase64String(base64EncodedData);

return System.Text.Encoding.UTF8.GetString(base64EncodedBytes);

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.