You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@dolphinscheduler.apache.org by "jiny.li@foxmail.com" <ji...@foxmail.com> on 2020/10/12 03:10:09 UTC
回复: Re: [DISCUSS]Which charset should we choose in mysql?
I agree we use utf8
jiny.li@foxmail.com
发件人： zhangchunyang
发送时间： 2020-10-12 11:03
收件人： dev
主题： Re:Re: [DISCUSS]Which charset should we choose in mysql?
UTF8 +1
在 2020-10-12 10:12:44，"JUN GAO" <ga...@apache.org> 写道：
>UTF8 +1
>
>yongqing <59...@qq.com> 于2020年10月11日周日 下午12:08写道：
>
>> +1
>>
>>
>>
>>
>> ------------------ 原始邮件 ------------------
>> 发件人:
>> "dev"
>> <
>> acm_master@163.com>;
>> 发送时间: 2020年9月30日(星期三) 中午12:34
>> 收件人: "dev@dolphinscheduler.apache.org"<
>> dev@dolphinscheduler.apache.org>;
>>
>> 主题: Re:[DISCUSS]Which charset should we choose in mysql?
>>
>>
>>
>> For us, UTF8 is enough to meet our requirements.
>>
>>
>>
>>
>> Best wishes！
>> CalvinKirs
>>
>>
>> On 09/30/2020 10:38，lgcareer2019@outlook.com<lgcareer2019@outlook.com>
>> wrote：
>> @Calvinkirs
>> Hi,Thanks for your suggestion. I think it's better to describe the reason
>> for what your suggestion.It's also easier to reach consensus.
>>
>>
>>
>> Thanks,
>> Gang Li
>>
>> DolphinScheduler(Incubator) PPMC
>> Gang Li 李岗
>>
>> lgcareer@apache.org
>>
>> From: CalvinKirs
>> Date: 2020-09-29 20:02
>> To: dev@dolphinscheduler.apache.org
>> Subject: Re:[DISCUSS]Which charset should we choose in mysql?
>>
>>
>> I think we don’t need utf8-mb4
>> Best wishes！
>> CalvinKirs
>>
>>
>> On 09/29/2020 16:09，lgcareer2019@outlook.com<lgcareer2019@outlook.com>
>> wrote：
>> Hi folks,
>> Welcome to discuss.I introduce the background and what should we discuss
>> first,If here is something didn't described clearly,please feel free to
>> tell me.
>> Backgound
>> Thougth dolphinscheduler uses the postgresql,but provided the mysql
>> construct sql to make it easier to use mysql.
>> The table of quartz used the charset `utf8mb4` and the other tables used
>> the charset `utf8`.
>> Here is a pr[1] suggest to use utf8.For the reason [2] below.
>>
>> What should we discuss?
>> What should we discussed is that `Which charset should we choose in mysql`?
>> Welcome everyone discuss,of course you can give other resolve method.
>>
>> 1.https://github.com/apache/incubator-dolphinscheduler/pull/3689
>> 2.When executing MySQL table creation statement, it will report that the
>> index length is not enough.
>> this will happen: Index column size too large. The maximum column size is
>> 767 bytes.
>>
>>
>>
>>
>> Thanks,
>> Gang Li
>>
>> DolphinScheduler(Incubator) PPMC
>> Gang Li 李岗
>>
>> lgcareer@apache.org
Re: [DISCUSS]Which charset should we choose in mysql?
Posted by "lgcareer2019@outlook.com" <lg...@outlook.com>.
Thanks for all everyone discussion,This discussion all agrees with use utf-8.
The pr[1] has already merged.
1.https://github.com/apache/incubator-dolphinscheduler/pull/3689
Best Regards
DolphinScheduler(Incubator) PPMC
Gang Li 李岗
lgcareer@apache.org
From: lidong dai
Date: 2020-11-03 21:07
To: dev
Subject: Re: Re: [DISCUSS]Which charset should we choose in mysql?
so our conclusion is to use utf8
Best Regards
---------------
DolphinScheduler(Incubator) PPMC
Lidong Dai 代立冬
dailidong66@gmail.com
---------------
On Mon, Oct 12, 2020 at 11:10 AM jiny.li@foxmail.com <ji...@foxmail.com>
wrote:
> I agree we use utf8
>
>
>
> jiny.li@foxmail.com
>
> 发件人： zhangchunyang
> 发送时间： 2020-10-12 11:03
> 收件人： dev
> 主题： Re:Re: [DISCUSS]Which charset should we choose in mysql?
> UTF8 +1
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 在 2020-10-12 10:12:44，"JUN GAO" <ga...@apache.org> 写道：
> >UTF8 +1
> >
> >yongqing <59...@qq.com> 于2020年10月11日周日 下午12:08写道：
> >
> >> +1
> >>
> >>
> >>
> >>
> >> ------------------ 原始邮件 ------------------
> >> 发件人:
> >> "dev"
> >> <
> >> acm_master@163.com>;
> >> 发送时间: 2020年9月30日(星期三) 中午12:34
> >> 收件人: "dev@dolphinscheduler.apache.org"<
> >> dev@dolphinscheduler.apache.org>;
> >>
> >> 主题: Re:[DISCUSS]Which charset should we choose in mysql?
> >>
> >>
> >>
> >> For us, UTF8 is enough to meet our requirements.
> >>
> >>
> >>
> >>
> >> Best wishes！
> >> CalvinKirs
> >>
> >>
> >> On 09/30/2020 10:38，lgcareer2019@outlook.com<lgcareer2019@outlook.com
> >
> >> wrote：
> >> @Calvinkirs
> >> Hi,Thanks for your suggestion. I think it's better to describe the
> reason
> >> for what your suggestion.It's also easier to reach consensus.
> >>
> >>
> >>
> >> Thanks,
> >> Gang Li
> >>
> >> DolphinScheduler(Incubator) PPMC
> >> Gang Li 李岗
> >>
> >> lgcareer@apache.org
> >>
> >> From: CalvinKirs
> >> Date: 2020-09-29 20:02
> >> To: dev@dolphinscheduler.apache.org
> >> Subject: Re:[DISCUSS]Which charset should we choose in mysql?
> >>
> >>
> >> I think we don’t need utf8-mb4
> >> Best wishes！
> >> CalvinKirs
> >>
> >>
> >> On 09/29/2020 16:09，lgcareer2019@outlook.com<lgcareer2019@outlook.com
> >
> >> wrote：
> >> Hi folks,
> >> Welcome to discuss.I introduce the background and what should we discuss
> >> first,If here is something didn't described clearly,please feel free to
> >> tell me.
> >> Backgound
> >> Thougth dolphinscheduler uses the postgresql,but provided the mysql
> >> construct sql to make it easier to use mysql.
> >> The table of quartz used the charset `utf8mb4` and the other tables used
> >> the charset `utf8`.
> >> Here is a pr[1] suggest to use utf8.For the reason [2] below.
> >>
> >> What should we discuss?
> >> What should we discussed is that `Which charset should we choose in
> mysql`?
> >> Welcome everyone discuss,of course you can give other resolve method.
> >>
> >> 1.https://github.com/apache/incubator-dolphinscheduler/pull/3689
> >> 2.When executing MySQL table creation statement, it will report that the
> >> index length is not enough.
> >> this will happen: Index column size too large. The maximum column size
> is
> >> 767 bytes.
> >>
> >>
> >>
> >>
> >> Thanks,
> >> Gang Li
> >>
> >> DolphinScheduler(Incubator) PPMC
> >> Gang Li 李岗
> >>
> >> lgcareer@apache.org
>
Re: Re: [DISCUSS]Which charset should we choose in mysql?
Posted by lidong dai <da...@gmail.com>.
so our conclusion is to use utf8
Best Regards
---------------
DolphinScheduler(Incubator) PPMC
Lidong Dai 代立冬
dailidong66@gmail.com
---------------
On Mon, Oct 12, 2020 at 11:10 AM jiny.li@foxmail.com <ji...@foxmail.com>
wrote:
> I agree we use utf8
>
>
>
> jiny.li@foxmail.com
>
> 发件人： zhangchunyang
> 发送时间： 2020-10-12 11:03
> 收件人： dev
> 主题： Re:Re: [DISCUSS]Which charset should we choose in mysql?
> UTF8 +1
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 在 2020-10-12 10:12:44，"JUN GAO" <ga...@apache.org> 写道：
> >UTF8 +1
> >
> >yongqing <59...@qq.com> 于2020年10月11日周日 下午12:08写道：
> >
> >> +1
> >>
> >>
> >>
> >>
> >> ------------------ 原始邮件 ------------------
> >> 发件人:
> >> "dev"
> >> <
> >> acm_master@163.com>;
> >> 发送时间: 2020年9月30日(星期三) 中午12:34
> >> 收件人: "dev@dolphinscheduler.apache.org"<
> >> dev@dolphinscheduler.apache.org>;
> >>
> >> 主题: Re:[DISCUSS]Which charset should we choose in mysql?
> >>
> >>
> >>
> >> For us, UTF8 is enough to meet our requirements.
> >>
> >>
> >>
> >>
> >> Best wishes！
> >> CalvinKirs
> >>
> >>
> >> On 09/30/2020 10:38，lgcareer2019@outlook.com<lgcareer2019@outlook.com
> >
> >> wrote：
> >> @Calvinkirs
> >> Hi,Thanks for your suggestion. I think it's better to describe the
> reason
> >> for what your suggestion.It's also easier to reach consensus.
> >>
> >>
> >>
> >> Thanks,
> >> Gang Li
> >>
> >> DolphinScheduler(Incubator) PPMC
> >> Gang Li 李岗
> >>
> >> lgcareer@apache.org
> >>
> >> From: CalvinKirs
> >> Date: 2020-09-29 20:02
> >> To: dev@dolphinscheduler.apache.org
> >> Subject: Re:[DISCUSS]Which charset should we choose in mysql?
> >>
> >>
> >> I think we don’t need utf8-mb4
> >> Best wishes！
> >> CalvinKirs
> >>
> >>
> >> On 09/29/2020 16:09，lgcareer2019@outlook.com<lgcareer2019@outlook.com
> >
> >> wrote：
> >> Hi folks,
> >> Welcome to discuss.I introduce the background and what should we discuss
> >> first,If here is something didn't described clearly,please feel free to
> >> tell me.
> >> Backgound
> >> Thougth dolphinscheduler uses the postgresql,but provided the mysql
> >> construct sql to make it easier to use mysql.
> >> The table of quartz used the charset `utf8mb4` and the other tables used
> >> the charset `utf8`.
> >> Here is a pr[1] suggest to use utf8.For the reason [2] below.
> >>
> >> What should we discuss?
> >> What should we discussed is that `Which charset should we choose in
> mysql`?
> >> Welcome everyone discuss,of course you can give other resolve method.
> >>
> >> 1.https://github.com/apache/incubator-dolphinscheduler/pull/3689
> >> 2.When executing MySQL table creation statement, it will report that the
> >> index length is not enough.
> >> this will happen: Index column size too large. The maximum column size
> is
> >> 767 bytes.
> >>
> >>
> >>
> >>
> >> Thanks,
> >> Gang Li
> >>
> >> DolphinScheduler(Incubator) PPMC
> >> Gang Li 李岗
> >>
> >> lgcareer@apache.org
>