[ 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)