You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@dolphinscheduler.apache.org by "lgcareer2019@outlook.com" <lg...@outlook.com> on 2020/09/29 08:09:04 UTC
[DISCUSS]Which charset should we choose in mysql?
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
>
回复: Re: [DISCUSS]Which charset should we choose in mysql?
Posted by "jiny.li@foxmail.com" <ji...@foxmail.com>.
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 zhangchunyang <18...@163.com>.
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 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
回复：[DISCUSS]Which charset should we choose in mysql?
Posted by yongqing <59...@qq.com>.
+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 CalvinKirs <ac...@163.com>.
For us, UTF8 is enough to meet our requirements.
Best wishes！
CalvinKirs
On 09/30/2020 10:38，lgcareer2019@outlook.com<lg...@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<lg...@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>.
@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<lg...@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 boyi <zh...@163.com>.
hi:
UTF-8 coding has met most of the requirements.
I think you should consider why it leads to: index column size too large
Instead of focusing on changing the encoding of the database
Normally, the database index should not be large
--------------------------------------
BoYi ZhangE-mail : zhangboyi_mx@163.com
On 09/29/2020 20:02，CalvinKirs<ac...@163.com> wrote：
I think we don’t need utf8-mb4
Best wishes！
CalvinKirs
On 09/29/2020 16:09，lgcareer2019@outlook.com<lg...@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 CalvinKirs <ac...@163.com>.
I think we don’t need utf8-mb4
Best wishes！
CalvinKirs
On 09/29/2020 16:09，lgcareer2019@outlook.com<lg...@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