Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.
Moderators: jmacgreg, michael, vgabler, John
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions. What to do if you have general, workflow or usability questions about OJS:
1. Read the documentation
. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.
2. take a look at the tutorials
. We will continue to add tutorials covering OJS basics as time goes on.
3. Post a question
. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support
subforum; if you have a development question, try the OJS Development
I have modified the list of users (for the journal administrator) to be alphabetical by last name, but 'order by last_name' in the MySQL (version 5) query doesn't treat accented characters correctly. I guess I don't have the character sets specified correctly. I've looked at the MySQL manual and searched previous posts, but haven't found an answer.
Specifically, the name 'Börgers', which is stored in the database as 'BÃ¶rgers' (but appears correctly on the web pages), is ordered between Battigalli and Becker. In config.inc.php I have
client_charset = utf-8
Is there an easy solution? Do I need to convert the database table somehow?
- Posts: 77
- Joined: Mon Jun 07, 2004 1:24 pm
- Location: Toronto, Canada
You'll have to enable the connection_charset and database_charset options in config.inc.php. This requires MySQL >= 4.1.1 or PostgreSQL >= 7.1.
Additionally, the next release of OJS will contain alphalists as a locale string, so you'll be able to jump to accented characters as well if (a) you add them to the alphalist and (b) you have the options above enabled.
Open Journal Systems Team
- Posts: 8426
- Joined: Wed Aug 10, 2005 12:56 pm
Return to OJS Editorial Support and Discussion
Who is online
Users browsing this forum: Bing [Bot] and 4 guests