The following table shows Unicode Literal examples.
Unicode Literal Expression |
Result of the expression |
---|---|
concat('This (', '\u00A9', ') is the copyright symbol'); |
Returns "This (©) is the copyright symbol"] |
'\f' == '\u000c'; '\t' == '\u0009'; '\b' == '\u0008'; '\'' == '\u0027'; '\0' == '\u0000'; '\t' == '\u005C\u0074'; '\\' == '\u005C\u005C'; |
Returns the Boolean value "true" if used in a gate condition. |
'\u004d\u0041'; |
Returns the letters "MA". The expression contains the 2 characters 'M' and 'A'. |
"My State Code" == '\u004d\u0041'; |
Checks if the column "My State Code", entered as a quoted identifier, is equal to 'MA'. |
concat('ABC','\u0044\u0045'); |
Returns the value “ABCDE” |
length(concat('ABC','\u0044\u0045')); |
Returns the value "5" |
length(concat('1\t2\t3', '\u0034\u0035')); |
returns the value "7" |