[airflow] 14/24: Fix typo in MySQL Database creation code (Set up DB docs) (#20102)

[po...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

potiuk pushed a commit to branch v2-2-test
in repository https://gitbox.apache.org/repos/asf/airflow.git

commit 8ecdcb9c2f8167d997d123a1aebc1d19de1e2ccb
Author: Richard Pelgrim <68...@users.noreply.github.com>
AuthorDate: Wed Dec 8 12:27:58 2021 +0100

    Fix typo in MySQL Database creation code (Set up DB docs)  (#20102)
    
    * Fix typo in MySQL Database creation code
    
    Character set `utf8` is an alias for `utf8mb3`, see docs linked below. This means collation should be set to `utf8mb3_unicode_ci`.
    Using `COLLATE utf8mb4_unicode_ci` (current code) throws the following error:
    `ERROR 1253 (42000): COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8'`
    
    (cherry picked from commit 9347832633a41b7b1e759d32ee756e7987f14a0d)
---
 docs/apache-airflow/howto/set-up-database.rst | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/docs/apache-airflow/howto/set-up-database.rst b/docs/apache-airflow/howto/set-up-database.rst
index f2f7fb6..14051b3 100644
--- a/docs/apache-airflow/howto/set-up-database.rst
+++ b/docs/apache-airflow/howto/set-up-database.rst
@@ -238,7 +238,7 @@ In the example below, a database ``airflow_db`` and user  with username ``airflo
 
 .. code-block:: sql
 
-   CREATE DATABASE airflow_db CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci;
+   CREATE DATABASE airflow_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    CREATE USER 'airflow_user' IDENTIFIED BY 'airflow_pass';
    GRANT ALL PRIVILEGES ON airflow_db.* TO 'airflow_user';