Hello all, I started administering an OJS portal that has been without a lot of upgrades and maintenance for a long time. As a result, the system has problems with accent characters, typical of incorrect charset configuration. The portal runs on FreeBSD whose default charset is ISO8859-1 and mysql…

Hi @rensousa , When you say that publications are not showing correctly, can you describe what you mean? Thanks, Alec Smecher Public Knowledge Project Team

hi @asmecher , I refer to the display of the accentuation of the Portuguese language - Brazil (pt-BR). I was able to fix it with the setting below: locale = pt-BR client_charset = utf-8 connection_charset = utf8 database_charset = utf8 charset_normalization = On It took me a while to realize that…

Hi guys, We are facing issues with character encoding when try to upgrade from 3.1.1.2 to 3.1.2.1. When we make a copy of the database of 3.1.1.2 and run OJS 3.1.2.1 with it, even before running the upgrade, all the spanish special characters like ´ or ñ are replaced by Ã³ or Ã‘. On the 3.1.1.2 it …

Hi @celuloide , Did you attempt to correct a utf8 to a utf-8? Look at e.g. Charset problems (ISO-8859-1 x UTF-8) - #3 by rensousa – the inconsistencies are important! Different libraries that OJS uses depend on UTF8 being written in different ways. Regards, Alec Smecher Public Knowledge Project T…

Hi @celuloide , The above settings posted by @rensousa are correct. You have invalid settings for both connection_charset and database_charset. The charset_normalization setting has been removed so it’s not doing anything. The invalid settings are going to the third-party ADODB library ; I’m not sur…

Thank you @asmecher , It is very possible our database have contents with wrong encoding, but the same database in another server with the settings I posted before looks to work fine: http://icono14.dysing.es/ojs/index.php/icono14/index However, if I put the @rensousa settings, mojibakes shows up. …

Hi @celuloide , I would suggest looking at the process you’re using to move the database between servers – maybe a missing DEFAULT CHARACTER SET utf8 clause on the CREATE DATABASE statement, or a missing --default-character-set parameter on mysqldump (off the top of my head)? If you can identify one…

Hello @asmecher , Thank you for sharing your leads on this. After upgrading to 3.3 and setting the utf-8 charset according to the config template, we found our database to have past/historical data with mixed charsets. New data is saved properly. To remedy old data, I found titles, subtitles, and a…

Hi @wilsonw , Can you please create a new post with your issue (and link back to this one, if you’d like). This is quite an older post, and creating a new one will help us keep the forum organized. Thank you, Roger PKP Team

PKP Community Forum

Charset problems (ISO-8859-1 x UTF-8)

Software Support

celuloide November 4, 2019, 10:12pm 6

Hi @asmecher,
Yes I did! I’ve tried every single combination, even clearing cache on between.
On our OJS 3.1.1-2 this setup works well…
imagen

Thanks for your help,

Daniel Becerra
ICONO14