Sunday, April 19, 2020

Fixed! WordPress database error Unknown character set: 'utf8_unicode_ci' for query

Issue

[19-Apr-2020 14:30:12 UTC] WordPress database error Unknown character set: 'utf8_unicode_ci' for query
CREATE TABLE wp_wc_admin_note_actions (
action_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
note_id BIGINT UNSIGNED NOT NULL,
name varchar(255) NOT NULL,
label varchar(255) NOT NULL,
query longtext NOT NULL,
status varchar(255) NOT NULL,
is_primary boolean DEFAULT 0 NOT NULL,
PRIMARY KEY (action_id),
KEY note_id (note_id)
) DEFAULT CHARACTER SET utf8_unicode_ci made by do_action_ref_array('generate_category_lookup_table'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\CategoryLookup->regenerate, Automattic\WooCommerce\Admin\Install::create_tables, dbDelta

Solution:

Few suggestions on the web were to change the database to following:
SET =utf8 COLLATE = utf8_unicode_ci