You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "zhao jintao (JIRA)" <ji...@apache.org> on 2019/04/09 03:58:00 UTC
[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&focusedCommentId=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)