15.10 - Example: UNICODE Combine UNICODE - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty
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"}