The example shows how to use the JSON Combine method to combine two JSON objects of CHARACTER SET LATIN.
The example uses the table(s) created earlier.
/* Result of LATIN combine LATIN is LATIN. */ SELECT MA.edata2.Combine(MB.edata2) FROM my_table AS MA, my_table2 AS MB WHERE MA.eno < 3;
Result: The result is a JSON instance with text in CHARACTER SET LATIN.
edata2.Combine(edata2) --------------------- {"name" : "Lewis","name" : "Lewis"} {"name" : "Lewis","name" : "Lewis"} {"name" : "Lewis","name" : "Lewis"} {"name" : "Lewis","name" : "Lewis"}