CREATE SET TABLE rv ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT,
val VARCHAR(20) CHARACTER SET unicode NOT CASESPECIFIC)
PRIMARY INDEX ( coll );
insert into rv(1,'test 1');
insert into rv(1,'test 10');
insert into rv(2,'test 2');
insert into rv(2,'test 20');
insert into rv(3,'และ43831'); -- because of this row I am getting error, If we remove it below query is working fine.
sel coll,TRIM(TRAILING ',' FROM (XMLAGG(TRIM(val)|| ',' ORDER BY 1 desc) (VARCHAR(1000))))as Test_Id
from rv group by 1
What client character set are you using for the INSERT?
Have you checked, e.g. using CHAR2HEXINT, to be sure proper UNICODE values have been stored?
what was the solution you implemented to get the XMLAGG to work?
Thanks ahead of time