Escape Characters

Escape Characters

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

Restrictions

  1. If there are escape characters in identifiers (database name, table name, column name)
  2. Identifier without ``: Error will be returned because identifier must be constituted of digits, ASCII characters or underscore and can’t be started with digits
  3. Identifier quoted with ``： Original content is kept, no escaping
  4. If there are escape characters in values
  5. 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.
  6. “%” and “_“ are used as wildcards in like. \% and \_ should be used to represent literal “%” and “_“ in like,. If \% and \_ are used out of like context, the evaluation result is “\%“and “\_“, instead of “%” and “_“.