[
https://issues.apache.org/jira/browse/TRAFODION-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liu ming resolved TRAFODION-2951.
---------------------------------
Resolution: Fixed
Fix Version/s: 2.3
> 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
> Fix For: 2.3
>
>
> 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)
