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 14:59:00 UTC
[jira] [Work started] (TRAFODION-2951) group_concat on utf8 column
with chinese character get messy code
[ 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)