Escape Characters
Below table is the list of escape characters used in TDengine.
| Escape Character | Actual Meaning |
|---|---|
\' | Single quote ' |
\" | Double quote " |
| \n | Line Break |
| \r | Carriage Return |
| \t | tab |
\\ | Back Slash \ |
\% | % see below for details |
\_ | _ see below for details |
note
Escape characters are available from version 2.4.0.4 .
Restrictions
- If there are escape characters in identifiers (database name, table name, column name)
- Identifier without ``: Error will be returned because identifier must be constituted of digits, ASCII characters or underscore and can't be started with digits
- Identifier quoted with ``： Original content is kept, no escaping
- If there are escape characters in values
- The escape characters will be escaped as the above table. If the escape character doesn't match any supported one, the escape character "" will be ignored.
- "%" and "_" are used as wildcards in
like.\%and\_should be used to represent literal "%" and "_" inlike,. If\%and\_are used out oflikecontext, the evaluation result is "\%"and "\_", instead of "%" and "_".
