If I open CSV using "notepad++",the Chinese character shows normally. But if open this file using excel, it shows garbled. All most of us using Windows and using excel to open CSV file contains kylin query result, I think this problem should be resolved, kylin should adapt to this format. Otherwise,we will always see garbled characters when we open CSV file using excel. Thanks. Best regards.
| | zjt | | 邮箱[email protected] | 签名由 网易邮箱大师 定制 On 04/09/2019 14:20, yongjie zhao wrote: oh , this is not a "bug", csv should not contains BOM, BOM is Microsoft private flag for utf-8 encode. On Tue, Apr 9, 2019 at 1:44 PM zjt <[email protected]> wrote: > Hi, yongjie > This is kylin bug. After I add bom identifier to the "csvWriter", the CSV > file can open normally by Excel, just need to add 1 line of code . > > > > zjt > 邮箱[email protected] > > <https://maas.mail.163.com/dashi-web-extend/html/proSignature.html?ftlId=1&name=zjt&uid=zhao_jintao%40163.com&iconUrl=https%3A%2F%2Fmail-online.nosdn.127.net%2Fqiyelogo%2FdefaultAvatar.png&items=%5B%22%E9%82%AE%E7%AE%B1zhao_jintao%40163.com%22%5D> > > 签名由 网易邮箱大师 <https://mail.163.com/dashi/dlpro.html?from=mail88> 定制 > > On 04/09/2019 12:49, yongjie zhao <[email protected]> wrote: > hi, this is may by Excel issue, you can open csv by Excel, select File --> > Import --> csv file, then click import. good luck. > > On Tue, Apr 9, 2019 at 11:50 AM zhao jintao (JIRA) <[email protected]> > wrote: > > > zhao jintao created KYLIN-3939: > > ---------------------------------- > > > > Summary: 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 > > > > > > 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) > > > >
