Strings and how they are processed

SQLScript provides a large number of built-in, scalar SQL functions for processing character strings. These will be explained in the following topics.


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