kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yongjie zhao <yongjie.z...@gmail.com>
Subject Re: [jira] [Created] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
Date Tue, 09 Apr 2019 06:20:12 GMT
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_jintao@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_jintao@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.zhao@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) <jira@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)
> >
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message