Hash Data Type

HASHTYPE Data Type

The hashtype can be used to store hash values, for example, MD5 hashes or Universally Unique Identifiers (UUID).

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.