SQLScript provides a large number of built-in, scalar SQL functions for processing character strings. These will be explained in the following topics.
Repetition
There are two types of string literals:
- Simple ASCII character strings are written in apostrophes, e.g.
'Text'{wpml_trans_unit_6_0_1_-1_0}>
- Unicode string literals becomes another big Ncode> in front of it, for example:
N'Jörg'{wpml_trans_unit_7_0_3_-1_0}>
The difference between ASCII strings and Unicode strings becomes clear in the following topic.
Pages 168-185 in the book