Hello, I imported database from local machine to remote machine and after import utf-8_general_ci remained, but I do not see non-english characters. The settings rlated to that part in OJS 3.0.2.0 are:
locale en_US
client_charset utf-8
connection_charset Off
database_charset Off
charset_normalization Off
Hello,
It is strange that the same database was in Windows in XAMPP and all characters were displayed correctly. When I type from my keyboard in new database with collation utf8_general_ci from my keyboard all characters are displayed correctly. Other installation of OJS with parameters I mentioned displays normally all characters.
My assumption is that in XAMPP in Windows it took keyboard mapping and displayed correctly just because of windows keyboard mapping, not because it is correct in general terms, to be used on servers.
Otherwise, characters typed from my keyboard would not be displayed correctly. Please feel free to comment.
locale en_US
client_charset utf-8
connection_charset Off
database_charset Off
charset_normalization Off
mysql default connection: latin1
ojs table encodings: utf8
You might end up with a situation where everything seems fine when looking from OJS, but the utf8 characters are actually saved as latin1, like this: Ô ß è
So I would check the server default connection setting first.