STRING
Description
The STRING
type handles sequences of characters, typically text. There are various String Functions available for processing STRING
input.
When entering STRING
constants manually, surround them with single quotes ('...'
). Single quotes within a STRING
constant have to be escaped with a backslash (\'
). A literal backslash within a STRING
constant also have to be escaped with a backslash (\\
).
Unicode characters are supported in all functions which support the STRING
type, unless specifically noted in the documentation for the given function. Everywhere the word "character" is used, "Unicode character" can be implicitly assumed, independent on the size of the underlying encoding of the Unicode string. For example the LEN function will count the number of Unicode characters in the input STRING
, and not the number of bytes in the underlying representation.
Strings are internally encoded using UTF-8. If an invalid UTF-8 encoding is encountered during a column load, the invalid characters are replaced with question marks ('?').
Example
[1] Create STRING constants. Note there are no escaping backslash characters present in the resulting | ||||||||||||
| ||||||||||||
|