We have upgraded our open journal systems site
http://www.radicalimagination.com to OJS2. We are using mysql 4.1.10 (For RHEL 4) and php 4.3.9
During the installation, we set the following parameters concerning the characterset for input/output. database connection, and dtabase storage (these parameters end up in config.inc.php after the installation):
client_charset = utf-8
connection_charset = utf8
database_charset = utf8
A query on the Journal's first page returned the error that the swedish language encoding was invalid--only we asked for utf-8 in the setup! To fix this, we changed the connection_charset and database_charset parameters in config.inc.php from "utf8" (this need not be the same as "utf-8", to "Off"). The problem was resolved. Our config.inc.php now reads as follows:
; 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
connection_charset = Off
; Database storage character set
; Must be set to "Off" if not supported by the database server
;database_charset = utf8
database_charset = Off
-FL