OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Accented characters in the database

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Postby asmecher » Fri Dec 15, 2006 11:43 am

Hi Wayne,

The inconsistent behavior is very strange, and not something I've encountered before. However, here are a few notes:

1. Depending on your OJS configuration, characters may or may not be stored in the database in UTF-8 encodings. This means that MySQL will see the accented-E character as "É" but when it is actually used it will be correctly handled by OJS. See connection_charset and database_charset directives in config.inc.php for specifics.

2. If an error message or warning is being displayed at the top of the page, accented characters will not display properly.

If your installation of MySQL supports using utf-8 connection and storage (i.e. the directives in 1. can be set to utf8), you should have better results.

Regards,
Alec Smecher
Open Journal Systems Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 8869
Joined: Wed Aug 10, 2005 12:56 pm

Accented characters in the database

Postby waynej » Tue Feb 06, 2007 11:54 am

We have just upgraded to OJS 2.1.1 and we are experiencing some odd and inconsistent behaviour with respect to accented characters served from the database.
In other words, the problems don't occur in HTML document submissions, only with content that is pulled directly from MySQL.
Specifically, our bilingual journal title features the character É (capital E, acute accent).
The character often appears correctly but occasionally does not.
Often reloading a given page will have inconsistent results (i.e. the character will appear as a nonsense character, then correctly when the page is reloaded).
I tried entering the character as the HTML entity "É" but that has even worse results.

Even more distressing is the fact that the character seems to get corrupted in the database even when no updates to the content have occurred.
The accented E turns into É.
Again, this behaviour is not consistent.
The accented E can be saved to the database, confirmed that it is still there, and then later it will have been corrupted.

Does anyone have any clues as to how to resolve these problems?

Wayne
waynej
 
Posts: 20
Joined: Wed Feb 08, 2006 2:54 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot], lathadevi and 3 guests