On Sat, August 18, 2007 15:53, C K wrote:
> Thanks to all,
> but the problem is that I am using external programs to insert data and I
> can't use MySQL functions directly. Can I call/implement such type of
> functions using MS Access 2003?
MD5() is not an encryption function. The MySQL manual states:
Calculates an MD5 128-bit checksum for the string. The value
is returned as a binary string of 32 hex digits, or NULL if
the argument was NULL. The return value can, for example,
be used as a hash key.
mysql> SELECT MD5('testing');
This is the “RSA Data Security, Inc. MD5 Message-Digest Algorithm.”
You might want to look at ENCODE() and DECODE() functions. Again from the manual:
Decrypts the encrypted string crypt_str using pass_str as
the password. crypt_str should be a string returned from ENCODE().
Encrypt str using pass_str as the password.
To decrypt the result, use DECODE().
The result is a binary string of the same length as str.
The strength of the encryption is based on how good the random
generator is. It should suffice for short strings.
These are all functions you use in your sql statement, so yes. They can be
used in MS Access.
+45 40 85 71 38
+66 870 133 224
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.