[GitHub] [airflow] uranusjr commented on pull request #17603: Fix MySQL database character set instruction

[GitBox <gi...@apache.org>]

uranusjr commented on pull request #17603:
URL: https://github.com/apache/airflow/pull/17603#issuecomment-901076735


   > Changing to this character set: `utf8 COLLATE utf8_general_ci;` solved the problem
   
   I’m very late here but is this really the correct solution? Setting a MySQL db to `utf8` is very frawned upon since this name is an alias to `utf8mb3`, which does not work with less common CJK characters and most emojis. `utf8mb4` is the much more preferred encoding. In fact, [the `utf8mb3` encoding and its `utf8` alias are actually deprecated in MySQL 8](https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html). So instead of recommending people to use `utf8mb3`, we should instead fix whatever is causing issues in the database so `utf8mb4` can be correctly applied.


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org