9.7.1.Strings

String literals are delimited with single quotes. A double single quote is an escape notation for a single quote character inside a string literal. Additionally, standard C language escapes are supported. Support of C escapes can be turned off for compatibility with other SQL databases by using the SQL_NO_CHAR_C_ESCAPE option in the configuration file or as an ODBC connection option.

Literal                 meaning
''                      <empty>
''''                    '
''''''                  ''
'\t\r\n\\'              tab, carriage return, newline, backslash
'\012'                  Character 012 octal, i.e. newline