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 <zhao_jin...@163.com> 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 > 邮箱zhao_jin...@163.com > > <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 <yongjie.z...@gmail.com> 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) <j...@apache.org> > 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) > > > >