DB check error COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

-- url of the page with the problem -- : http://localhost
-- HikaShop version -- : 3.0.1
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6.x
-- Browser(s) name and version -- : FF

When I check the database for errors from HikaShop I get an error: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' SQL=SELECT DISTINCT order_status COLLATE utf8_bin FROM `#__hikashop_order` WHERE order_type = 'sale'

All my tables are either utf8mb4_general_ci or utf8_general_ci.

Regards

Hi,

That's normal. We only support utf8, not utf8mb4. Normally, when the HikaShop tables are created, they are all created with utf8_general_ci as you can see in the file administrator/components/com_hikashop/tables.sql
So please don't change the charset of the tables and you won't get that error message.