Connection_charset = off then OJS 3.3.0.5 shows HTTP ERROR 500

OJS 3.3.0.5

Server Information

Setting Name Setting Value
OS platform Linux
PHP version 7.4.15
Apache version Apache/2.4.6 (CentOS)
Database driver mysql
Database server version 5.5.60-MariaDB

UPDATED by setting

; Client output/input character set
client_charset = utf-8

; Database connection character set
connection_charset = utf8

BUT earlier version (OJS 3.2.1.4) setting was
connection_charset = off

; Database storage character set
; Must be set to “Off” if not supported by the database server
database_charset = off

Using that setting unable to upgrade. Managed to update by setting to

; Client output/input character set
client_charset = utf-8

; Database connection character set
connection_charset = utf8

BUT there are so many unknown characters in the title and the meta data e.g. [CONSUMERS’] instead of CONSUMER’S.

When set to connection_charset = off as before in the configuration file then got HTTP ERROR 500 .

Many journals with OFF having this problem and specially Arabic journals.

I hope that some on give some solution. If I manage to turn off database_charset then it may solved but I can’t turned off due to HTTP ERROR 500

Thanks.