I am using OJS 2.4.2.
If there is a special character in any entry in my system (such as in title, abstract, author name, etc), after the data is entered into the database, the data cannot be loaded back to the form again. For example, if there is a special character in article title, when editing metadata, the title field is empty, also, when trying to send review request, the prepared email template won’t load since the title containing special character will be populated into the template, which prevents template from loading into the email body field.
this problem should be the same in nature as this one: Reviewer email not working
I checked my database character set by running: show variables like “character_set_database”; the result returned is:
character_set_database latin1 (this is a surprise to me, I supposed it should have been utf-8)
The settings in my config file are:
; Default locale
locale = en_US
; Client output/input character set
client_charset = utf-8
; Database connection character set
connection_charset = Off
; Database storage character set
database_charset = Off
; Enable character normalization to utf-8 (recommended)
; charset_normalization = Off
Then I changed the last setting to ; charset_normalization = utf-8
the change did not make any difference.
My question is what is the easiest solution to my problem? Can i fix it by simply changing character_set_database to utf-8?, if yes, how?
Thank you very much in advance.