Example: UNICODE Combine UNICODE

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
The example shows the result when two JSON objects are combined with both JSON objects having CHARACTER SET UNICODE, which results in a JSON instance with text in CHARACTER SET UNICODE.
The example uses the table(s) created earlier.
/* Result of UNICODE combine UNICODE is UNICODE */

SELECT MA.edata.Combine(MB.edata) 
FROM my_table AS MA, my_table2 AS MB
WHERE MA.eno < 3;

Result: When combining UNICODE and UNICODE, the result is a JSON instance with text in CHARACTER SET UNICODE.

edata.Combine(edata)
--------------------
{"name" : "Cameron","name" : "Cameron"}
{"name" : "Cameron","name" : "Melissa"}
{"name" : "Melissa","name" : "Cameron"}
{"name" : "Melissa","name" : "Melissa"}