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
Please advise
Have you tried
client_charset utf-8
connection_charset utf8
database_charset utf8
charset_normalization Off
Probably your mysql connect default is latin1?
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.
Thanks,
Maybe your default connection in XAMPP is utf8?
With this combination:
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.
Server connection collation in phpMyAdmin is: utf8b4_unicode_ci
I guess that should not create problems