You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by GitBox <gi...@apache.org> on 2021/02/10 14:24:42 UTC
[GitHub] [airflow] Gabriel39 opened a new issue #14172: Support utf8mb4 character set better for mysql
Gabriel39 opened a new issue #14172:
URL: https://github.com/apache/airflow/issues/14172
**Description**
Although the utf8mb4 character set is more and more popular for MySQL (actually, utf8mb4 becomes default character set already) and maybe [utf8mb3 will be removed in future](https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html), there are still some problems in current Airflow.
So if you use utf8mb4 as character set, you should set `sql_engine_collation_for_ids=utf8mb3_general_ci`.
**Use case / motivation**
In Airflow 2.0, when i use mysql database and utf8mb4, i must set `sql_engine_collation_for_ids=utf8mb3_general_ci`. Otherwise, the length of primary key of table xcom will exceed the maximum value 3072 bytes.
So I think we should address this problem to avoid more problems in future.
**Are you willing to submit a PR?**
I'd be willing to
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk closed issue #14172: Support utf8mb4 character set better for mysql
Posted by GitBox <gi...@apache.org>.
potiuk closed issue #14172:
URL: https://github.com/apache/airflow/issues/14172
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] boring-cyborg[bot] commented on issue #14172: Support utf8mb4 character set better for mysql
Posted by GitBox <gi...@apache.org>.
boring-cyborg[bot] commented on issue #14172:
URL: https://github.com/apache/airflow/issues/14172#issuecomment-776740770
Thanks for opening your first issue here! Be sure to follow the issue template!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [airflow] potiuk commented on issue #14172: Support utf8mb4 character set better for mysql
Posted by GitBox <gi...@apache.org>.
potiuk commented on issue #14172:
URL: https://github.com/apache/airflow/issues/14172#issuecomment-776800178
We are not going to do anything about it until MySQL releases a new version. Similarly as in 5.6->5.7 they are likely to increase maximum index size and if they do, the problem will be resolved without any action from our side. This is the plan.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org