String literals

Standard string literals

A string literal is a sequence of characters enclosed within single quotes (’). For example, 'Database' is a string literal.

To include a single-quote character within a string literal, you can use two consecutive single quotes. For example, 'Stream processing''s advantages' is a valid string literal that incorporates a single-quote character.

String literals with C-style escapes

String literals with C-style escapes use escape sequences to represent special characters within a string, just as in the C programming language. These literals are constructed by prepending the letter e to the string literal. For example, e'abc\n\tdef'.

The following escape sequences are supported:

Escape sequenceInterpretation
\bbackspace
\fform feed
\nnewline
\rcarriage return
\ttab
\o, \oo, \ooo (o = 0–7)octal byte value
\xh, \xhh (h = 0–9, A–F)hexadecimal byte value
\uXXXX (x = 0–9, A–F)16-bit hexadecimal Unicode character value
\UXXXXXXXX (x = 0–9, A–F)32-bit hexadecimal Unicode character value

Numeric literals

RisingWave supports expressing numeric literals in various number systems, including decimal (base 10), hexadecimal (base 16), octal (base 8), and binary (base 2). Here are some examples:

2147       -- Decimal
0x42e3     -- Hexadecimal
0o664      -- Octal
0b1101     -- Binary

Numeric literals in different bases provide you with flexibility in choosing the most suitable representation for specific needs.