liu ming created TRAFODION-2951:
-----------------------------------

             Summary: 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


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)

Reply via email to