Strings

Some clauses compare to a full text string instead of a term. When the text string conforms to the syntax of a term, it can be provided unquoted. Example:

Name=Smith

The value Smith is a string because “=” follows the field name; if the field name was followed by “:”, Smith would be treated as a term. See Equality Clauses described later.

When the string consists of multiple terms or contains characters not allowed in terms, the string must be enclosed in single or double quotes. Example:

Name="John Smith"

Note that to Doradus, object IDs are also strings. Therefore, when used in DQL queries, object ID literals may be provided as a single unquoted term or as a quoted string. Examples:

_ID=ISBN1234

Sender='cihSptpZrCM6oXaVQH6dwA=='

In a string, the characters ? and * are treated as wildcards as they are in terms. If a string needs a ? or * that must be used literally, they must be escaped. Escaping can also be used for non-printable or other characters. Doradus uses the backslash for escaping, and there are two escape formats:

•	\x: Where x can be one of these characters: t (tab character), b (backspace), n (newline or LF), r (carriage return), f (form feed), ' (single quote), " (double quote), or \ (backslash).

•	\uNNNN: This escape sequence can be used for any Unicode character. NNNN must consist of four hex characters 0-F.

For example, the string "Hello!World" can also be specified as "Hello\u0021World".