You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2018/02/03 00:42:00 UTC
[jira] [Created] (TRAFODION-2951) group_concat on utf8 column with
chinese character get messy code
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)