You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by yongjie zhao <yo...@gmail.com> on 2019/04/09 04:49:39 UTC
Re: [jira] [Created] (KYLIN-3939) Open csv files from query exported,
the Chinese characters are garbled
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) <ji...@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)
>
Re: [jira] [Created] (KYLIN-3939) Open csv files from query
exported, the Chinese characters are garbled
Posted by zjt <zh...@163.com>.
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 <zh...@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 <yo...@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) <ji...@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)
> >
>
>
Re: [jira] [Created] (KYLIN-3939) Open csv files from query exported,
the Chinese characters are garbled
Posted by yongjie zhao <yo...@gmail.com>.
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 <zh...@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 <yo...@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) <ji...@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)
> >
>
>
Re: [jira] [Created] (KYLIN-3939) Open csv files from query
exported, the Chinese characters are garbled
Posted by zjt <zh...@163.com>.
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
|
签名由 网易邮箱大师 定制
On 04/09/2019 12:49, yongjie zhao 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) <ji...@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)
>