[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16837065#comment-16837065 ] ASF subversion and git services commented on KYLIN-3939: Commit 93cf901e07ea67e1612eafd2333e90c3998100ec in kylin's branch refs/heads/2.6.x from zhaojintaozhao [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=93cf901 ] KYLIN-3939 Add BOM character to the exported csv (#602) > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > Fix For: v2.6.2 > > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16825806#comment-16825806 ] ASF GitHub Bot commented on KYLIN-3939: --- nichunen commented on pull request #602: KYLIN-3939 add BOM character,slove the bug that it shows Chinese garb… URL: https://github.com/apache/kylin/pull/602 This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16825807#comment-16825807 ] ASF subversion and git services commented on KYLIN-3939: Commit c42aafd0bd58935b5ac5836103f05e5208e84ef2 in kylin's branch refs/heads/master from zhaojintaozhao [ https://gitbox.apache.org/repos/asf?p=kylin.git;h=c42aafd ] KYLIN-3939 Add BOM character to the exported csv (#602) > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16817161#comment-16817161 ] ASF GitHub Bot commented on KYLIN-3939: --- zhaojintaozhao commented on pull request #602: KYLIN-3939 add BOM character,slove the bug that it shows Chinese garb… URL: https://github.com/apache/kylin/pull/602 I find that if i open csv file using "notepad++", the Chinese characters are displayed normally. Then I convert this file to "UTF-8-BOM", then save this file. Then I open csv file using excel and the Chinese characters are displayed normally. Then I add BOM identifier to the query result to be output in "QueryController.java"，I can open csv files usring excel and it displays normally. The system work fine after this change. This commit just fix this bug. This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
[ https://issues.apache.org/jira/browse/KYLIN-3939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812992#comment-16812992 ] zhao jintao commented on KYLIN-3939: I find that if i open csv file using "notepad++", the Chinese characters are displayed normally. Then I convert this file to "UTF-8-BOM", then save this file. Then I open csv file using excel and the Chinese characters are displayed normally. Then I add BOM identifier to the query result to be output in "QueryController.java"，I can open csv files usring excel and it displays normally. The system work fine after this change. I will fix this bug today. Best regards Zhao Jintao > Open csv files from query exported, the Chinese characters are garbled > > > Key: KYLIN-3939 > URL: https://issues.apache.org/jira/browse/KYLIN-3939 > Project: Kylin > Issue Type: Bug > Components: REST Service >Affects Versions: v2.5.2 >Reporter: zhao jintao >Assignee: zhao jintao >Priority: Minor > > Hi team; > I query sql in kylin portal and then press "Export" button to download the > result; the result is csv files. I open the csv file using excel to get the > query results. > But I find that if the result has Chinese characters, the excel will show > Chinese characters garbled. > Does any one face this problem? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
