You are viewing the PKP Support Forum | PKP Home Wiki

Database and Form Fields too small

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

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Database and Form Fields too small

Postby ramon » Thu Apr 07, 2005 6:04 am

Dear OJS Developers,

We are running into form and database field size problems. Since the system is meant to be international, but it does not create separate databases for each language, we must input all the language content in one field (i.e: title, abstract, author bio, as well as all the journal's about content!).

Unfortunately, there are HTML form field size limitations, as well as database size limitations, which truncates content. Some of the section's titles get truncated too, as well as telephone fields which do not accept cell phone number sizes.

Also, in Brazil a phone number may contain at least 8 digits, plus 2 digit area code, plus international code, and if you want to add your cell phone there is no field for it, so it is typed in the same field.

I would recommend changing all database fields to either 255 chars, or better all to TEXT, as well as remove all size limitations in form fields.

This would solve many content limitatons.

Another solution is to create and "Add language button", so each field could have a translation, and add a cell phone field in user registration. I believe I'm part of "the less than 1%" of the population in Brazil who does NOT own a cell phone.
Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest