Unicode literal examples - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
Last edition
2024-08-20
Last publish date
2024-08-20T21:40:14.000381

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"