I am trying to use XMLAGG to transpose the row-wise data to comma separated value in Teradata 15. Its working fine with English (LATIN character set) characters. But while I am using other characters (Unicode character set) I am getting 'string contains untranslatable character' error.
Please suggest how to resolve the issue.

Error table is getting loaded with error code "6706" while doing TPT EXTRACT/LOAD using TPT Binary Mode.
In case of text mode I understand we need to handle this case.
even for BINARY mode also do we handle this case.?