Arabic font missing

Hello.

I upgraded ojs 3.1.2 to the latest version 3.2.0. Suddenly the arabic text missing and turned into ???.. (see the screenshot)

image

Thanks

Hi @Emi_Naza,

See After last upgrade missing č ć š ž signs.

Regards,
Alec Smecher
Public Knowledge Project Team

Ive changed the Localization setting in my config file to:

[i18n]

; Default locale
locale = en_US

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

; Database connection character set
; Must be set to “Off” if not supported by the database server
; If enabled, must be the same character set as “client_charset”
; (although the actual name may differ slightly depending on the server)
connection_charset = utf8

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

; Enable character normalization to utf-8 (recommended)
; If disabled, strings will be passed through in their native encoding
; Note that client_charset and database collation must be set
; to “utf-8” for this to work, as characters are stored in utf-8
charset_normalization = Off

but nothing happens

i have tried this method on version 3.1.2 and it works… but not in version 3.2.0

Hi @Emi_Naza,

I suspect your database is created with the wrong default character set. What do you get for the following SQL query?

SELECT @@character_set_database, @@collation_database;

Regards,
Alec Smecher
Public Knowledge Project Team

oh… i got this:

@@character_set_database @@collation_database
latin1 latin1_swedish_ci

:sweat:

image

I have changed the character to utf8_unicode_ci but still the TITLE, ABSTRACT and REFERENCE turn to question marks.

see: http://upgrade.usimjournal.com/index.php/jfatwa/article/view/35

Hi @Emi_Naza,

Did you change the encodings with the database contents already populated? If so, you may need to transcode the contents. (This is more of a database administration question, so you might be able to find clear guidance e.g. on StackOverflow.com.)

Regards,
Alec Smecher
Public Knowledge Project Team