Comments on Mysql return error Unknown collation: 'utf8mb4_0900_ai_ci' when run rails db:schema:load
Post
Mysql return error Unknown collation: 'utf8mb4_0900_ai_ci' when run rails db:schema:load Question
+3
−0
I tried to install on my free GCP VM compute but when run rails db:schema:load
return error:
-- create_table("abilities", {:options=>"ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci", :force=>:cascade})
rails aborted!
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown collation: 'utf8mb4_0900_ai_ci': CREATE TABLE `abilities` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `community_id` bigint, `name` varchar(255), `description` text, `internal_id` varchar(255), `icon` varchar(255), `post_score_threshold` decimal(10,8), `edit_score_threshold` decimal(10,8), `flag_score_threshold` decimal(10,8), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `summary` text, INDEX `index_abilities_on_community_id` (`community_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
It was worked fine on my Mac OS, what's wrong with my ubuntu?
Maybe I need to install/activate utf8mb4_0900_ai_ci, but how to do it? I cant find any resource about install it, just suggestion to change it to utf8mb4_general_ci
My software specification:
- Ubuntu 18.04
- mysql 5.7.32-0ubuntu0.18.04.1-log
- Ruby 2.6.6
- gem 3.0.3
- rails 5.2.4.4
- rbenv 1.0.0
1 comment thread