HASHTYPE data type

The HASHTYPE data type can be used to store hash values such as MD5 hashes or universally unique identifiers (UUID).

There is no special literal for the HASHTYPE data type. Values are defined as strings and must be delimited with single quotes. Dashes (-) in the input hash string will be ignored. Curly brackets surrounding the input hash string are allowed.

Data type Note

HASHTYPE(n BYTE)

or

HASHTYPE(m BIT)

n = size in bytes (optional)

1 ≤ n ≤ 1024

m = size in bits (optional)

8 ≤ m ≤ 8192 (m must always be a multiple of 8)

Default = 16 BYTE