Published in : 2022-01-09
I am facing this error #1273 - Unknown collation: 'utf8mb4_0900_ai_ci' when i am trying to import the database backup which i got from the server to my localhsot.
any thoughts on How can I figure out this issue?
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
Jo Micheal Date : 2022-01-09
You can handle this error by replacing the type of collation into the file,
you can search for “utf8mb4_0900_ai_ci” with “utf8mb4_general_ci” and “CHARSET=utf8mb4” with “CHARSET=utf8“.
so replace lines like
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Join our community and get the chance to solve your code issues & share your opinion with usSign up Now