unknown collation: 'utf8mb4_0900_ai_ci' stackoverflow

Bosco answered on June 2, 2021 Popularity 3/10 Helpfulness 2/10

related Unknown collation: 'utf8mb4_0900_ai_ci' drupal

related unknown collation 'utf8mb4_0900_ai_ci'

Comment

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
replace with
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

Popularity 3/10 Helpfulness 2/10 Language whatever

Tags: stack-overflow whatever

Link to this answer
Share Copy Link

Contributed on Sep 20 2021

Bosco

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

sed -i '' 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' db_name.sql

Popularity 9/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: drupal dr

Link to this answer
Share Copy Link

Contributed on Jun 02 2021

lakshay.me

0 Answers Avg Quality 2/10

Comment

sed -i 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' backup.sql  
sed -i 's/CHARSET=utf8mb4/CHARSET=utf8/g' backup.sql

Popularity 9/10 Helpfulness 4/10 Language shell

Source: tecadmin.net

Tags: collation coll

Link to this answer
Share Copy Link

Contributed on Mar 24 2022

kkmitra

0 Answers Avg Quality 2/10