kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zjt <zhao_jin...@163.com>
Subject Re: [jira] [Created] (KYLIN-3939) Open csv files from query exported, the Chinese characters are garbled
Date Tue, 09 Apr 2019 06:59:05 GMT
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
|
|
邮箱zhao_jintao@163.com
|

签名由 网易邮箱大师 定制

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 <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&gt;
>
> 签名由 网易邮箱大师 <https://mail.163.com/dashi/dlpro.html?from=mail88&gt;
定制
>
> 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