I am using GROUP_CONTCAT to return comma separated values. This works perfectly fine with small strings as it return a VARCHAR type in the xml.
However, with larger strings the module returns special characters. Upon testing the XML Information in the module I noticed that it returned a BLOB type.
Is it possible to return actual values in XML ?
Retrieving data ...