potiuk commented on a change in pull request #14174: URL: https://github.com/apache/airflow/pull/14174#discussion_r573831750
########## File path: docs/apache-airflow/howto/set-up-database.rst ########## @@ -91,6 +91,8 @@ without any cert options provided. However if you want to use other drivers visit the `MySQL Dialect <https://docs.sqlalchemy.org/en/13/dialects/mysql.html>`__ in SQLAlchemy documentation for more information regarding download and setup of the SqlAlchemy connection. +In addition, you also should pay particular attention to MySQL's encoding. Although the utf8mb4 character set is more and more popular for MySQL (actually, utf8mb4 becomes default character set in MySQL8.0 already), there are still some problems in current Airflow (See more details in `#7570 <https://github.com/apache/airflow/pull/7570>`__.). To avoid unexpected problems, if you use utf8mb4 as character set, you should set ``sql_engine_collation_for_ids=utf8mb3_general_ci``. Review comment: It's not a problem, it's a feature ;) ---------------------------------------------------------------- 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: [email protected]
