Name
md5, md5_box, mdigest5 — returns the md5 checksum of its argument
Synopsis
checksum md5(
|
in str varchar); |
checksum md5_box(
|
in val any); |
Description
md5 calculates the MD5 checksum of its argument. The
md5 message digest algorithm is defined in
RFC1321.
md5_box calculates the MD5 checksum over the
in-memory representation of any boxed Virtuoso value (strings, numbers,
vectors, arrays, etc.). Unlike md5, which operates on
the textual representation of a string argument,
md5_box hashes the raw serialized form of the box and
is therefore useful for fingerprinting arbitrary SQL values.
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
Table 24.50. Errors signalled by
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
Examples
Example 24.233. Simple example
SQL> select md5 ('blah blah');
callret
VARCHAR
_______________________________________________________________________________
ae661d08d1ca1576a6efcb82b7bc502f
1 Rows. -- 4 msec.