The following table shows the BOOLEAN data type in ESQL:
| Data type: | Literals: |
|---|---|
| BOOLEAN | TRUE, FALSE, UNKNOWN (case-insensitive) |
The following table shows the NULL data type in ESQL:
| Data type: | Literals: |
|---|---|
| NULL | NULL |
The following table shows the NUMERIC data types in ESQL:
| Data type: | Literals: |
|---|---|
| FLOAT | An unquoted string of digits that contains a decimal point. Examples: 123.4. |
| INTEGER | An unquoted string of digits not containing a decimal point. For example:1008874. |
| Data type: | Literals: |
|---|---|
| CHARACTER | '1000 Main Street' |
To specify a single quote character within a string of type CHARACTER, insert a second single quote character immediately before the single quote character (for example, the string 'customer''s address' specifies the characters "customer's address").