Hash Data Type

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.

Exasol type (ANSI type) Note

Exasol type (ANSI type)	Note
`HASHTYPE[(n BYTE \| m BIT)]`	1 ≤ n ≤ 1024 BYTE 8 ≤ m ≤ 8192 BIT Default = 16 BYTE When specifying the size in bits, the number of bits `m` must always be a multiple of 8.

HASHTYPE[(n BYTE | m BIT)]

1 ≤ n ≤ 1024 BYTE
8 ≤ m ≤ 8192 BIT

Default = 16 BYTE

When specifying the size in bits, the number of bits m must always be a multiple of 8.