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|
|HASHTYPE[(n BYTE | m BIT)]||
1 ≤ n ≤ 1024 BYTE
Default = 16 BYTE
When specifying the size in bits, the number of bits m must always be a multiple of 8.