[ https://issues.apache.org/jira/browse/TRAFODION-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TRAFODION-2951 started by liu ming. ------------------------------------------- > group_concat on utf8 column with chinese character get messy code > ----------------------------------------------------------------- > > Key: TRAFODION-2951 > URL: https://issues.apache.org/jira/browse/TRAFODION-2951 > Project: Apache Trafodion > Issue Type: Bug > Reporter: liu ming > Assignee: liu ming > Priority: Major > > 1. create table t_pivot(role_id VARCHAR(50 BYTES) CHARACTER SET UTF8,role_nm > VARCHAR(200 BYTES) CHARACTER SET UTF8); > 2. > insert into t_pivot values('role_01','管理员'); > insert into t_pivot values('role_02','审计员'); > > 3. GROUP_CONCAT > SQL>select GROUP_CONCAT(role_nm) from t_pivot; > (EXPR)------------------------------------- > ?????????,???è????? > > SQL>select GROUP_CONCAT(role_id) from t_pivot; > (EXPR) > ------------------------------------- > role_01,role_02 -- This message was sent by Atlassian JIRA (v7.6.3#76005)