binary password in SQL??

Thread view:

timasmith@hotmail.com - 29 Apr 2006 05:14 GMT

Hi,

I used this function to convert the password to a hashe value

public static byte[] getKeyedDigest(byte[] buffer, byte[] key)
throws NoSuchAlgorithmException {
MessageDigest md5 = MessageDigest.getInstance("MD5");
md5.update(buffer);
return md5.digest(key);
}

But the output was completely invalid to use for SQL to save in a field

?ª4úø...¦ÁIÃÑäjÈ

Without doing a binary save - how can I easily convert the output to
regular ascii?

thanks

Tim

Reply to this Message

Roland de Ruiter - 29 Apr 2006 10:38 GMT

> Hi,
>
[quoted text clipped - 17 lines]
>
> Tim

Convert the byte array (IIRC 16 bytes for MD5) to a hexadecimal String
representation (2 characters for each byte: 32 in total for MD5)

byte[] md5sum = getKeyedDigest(yourBuffer, yourKey);
StringBuffer buf = new StringBuffer(2 * md5sum.length);
for (int i = 0; i < md5sum.length; i++ {
// convert signed byte to its "unsigned" integer value
int byte_i = md5sum[i] & 0x000000ff;
// convert i'th byte to hexadecimal string repr
String hex = Integer.toHexString(byte_i);
// add leading 0 if i'th byte was less than 16.
if (hex.length() == 1) {
buf.append('0'); // add leading 0
} /* else {
// otherwise hex repr of the i'th byte consists of 2 chars
assert hex.length() == 2
} */
buf.append(hex);
}
String md5sumRepr = buf.toString();
return md5sumRepr;
--
Regards,

Roland

Reply to this Message

timasmith@hotmail.com - 29 Apr 2006 14:37 GMT

awesome thanks

Reply to this Message

Aki Tuomi - 29 Apr 2006 11:08 GMT

timasmith@hotmail.com kirjoitti:

> Hi,
>
[quoted text clipped - 17 lines]
>
> Tim

There is no reason why you coulnd't save binary data in SQL database.
Unless of course you are using some DBM or database that does not
support binary data at all. There is a reason for VARBINARY and BLOB
data types. =)

Aki

Reply to this Message

binary password in SQL??

Free Magazines