# 22. Virtuoso Functions Guide - md5

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
dsig_template_ext
md5
md5_final
md5_init
md5_update
x509_certificate_ver...
xenc_x509_certificat...
xenc_decrypt_soap
xenc_delete_temp_key...
xenc_encrypt
xenc_get_key_algo
xenc_get_key_identif...
xenc_key_3des_create
xenc_key_3des_rand_c...
xenc_key_3des_read
xenc_key_aes_create
xenc_key_aes_rand_cr...
xenc_key_dsa_create
xenc_key_dsa_read
xenc_key_rsa_read
xenc_key_create_cert
xenc_key_exists
xenc_key_inst_create
xenc_key_remove
xenc_key_serialize
xenc_set_primary_key
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## md5

returns the md5 checksum of its argument
checksum md5 (in str varchar);
Description

md5 calculates the MD5 checksum of its argument. The md5 message digest algorithm is defined in RFC1321.

Parameters
str – A string or string_output containing the data for calculating the message digest.
Return Types

A string of 32 lowercase alphanumeric characters.

Errors

SQLState | Error Code | Error Text | Description
--- | --- | --- | ---

Examples

    SQL> select md5 ('blah blah');
    callret
    VARCHAR
    _______________________________________________________________________________

    ae661d08d1ca1576a6efcb82b7bc502f

    1 Rows. -- 4 msec.

See Also

RFC1321