Changed my hosting, having problems displaying Turkish characters

I wanted upgarde from OJS 2.4.8.1 to OJS 3 but was having problems so I decide to change my hosting company and after few days I will try to upgrade to latest OJS…I am currently using OJS 2.4.8.1

Anyways it looks like I moved my site ok, only Turkish characters not displaying properly.

Following is the info from my config.php and also from the datbase, just to give you an idea.

Am I missing something stupid?

Localization Settings from the config.php

;;;;;;;;;;;;;;;;;;;;;;;;;
; Localization Settings ;
;;;;;;;;;;;;;;;;;;;;;;;;;

[i18n]

; Default locale
locale = tr_TR

; 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
; 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
; (Note that this is generally no longer needed, as UTF8 adoption is good.)
charset_normalization = Off

And info from the database

CREATE DATABASE IF NOT EXISTS user_ojs DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE user_ojs;



– Table structure for table access_keys

CREATE TABLE access_keys (
access_key_id bigint(20) NOT NULL,
context varchar(40) NOT NULL,
key_hash varchar(40) NOT NULL,
user_id bigint(20) NOT NULL,
assoc_id bigint(20) DEFAULT NULL,
expiry_date datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Hi @OJS_Atd,

Your CREATE DATABASE statement specifies latin1, but everything else looks like it expects UTF-8. The best configuration would use UTF-8 everywhere. (The inconsistencies between utf-8 and utf8 in config.inc.php are necessary – don’t clean them up, even though it’s tempting!)

Regards,
Alec Smecher
Public Knowledge Project Team