Upgrade from 3.2.1.4 to 3.3.0.19 encounter problem

Software Support
1

Upgraded 3.1.2.4 to 3.2.1.4 = Successful (with the following modifications)

SET default_storage_engine = ‘InnoDB’;

Tried to upgrade from 3.2.1.4 to 3.3.0.19 with the following;

‘engine’ => ‘InnoDB’,

The upgrade doesn’t proceed with

connection_charset = utf-8

It proceeds succussfully with

connection_charset = utf8

but characters show error for example (Côte d’Ivoire) appears (Côte d’Ivoire)

I tried to upgrade with connection_charset = utf8 and later changed connection_charset = utf-8 but website doesn’t load.

It doesn’t proceed with;

connection_charset = utf8

2

have you change the table collation in datababase with utf8mb4_general_ci ?

3

I restored backup to OJS 2.4.8.5. Now I see mix collation which I changed to

utf8mb4_general_ci

I changed type of some tables from myISAM to InnoDB. Now all tables are utf8mb4_general_ci and InnoDB.

In OJS 2.4.8.5 when I change connection_charset = off to connection_charset = utf8 it show the same error (some words are changed like “Côte d’Ivoire” is changed to Côte d’Ivoire) but when I change it to connection_charset = utf-8 it show no error.

The issue is I want to upgrade to the latest version one by one it do not show error from 2.8.45 to 3.1 and 3.2 but later when I want to upgrade 3.2 to 3.3, it requires utf8 (same error exist). It do not proceed with upgrading from 3.2 to 3.3 using utf-8.