Fellas,
During the last training we provided I ran into a problem with the database charset.
The tblusers fields chUsername, chPassword, chFirstName, chLastName where set to iso-swedish-ci.
I'm thinking this is the MySQL installation that is not set to UTF-8. Must the database creation script be modified to solve this issue? I think this is a version problem, because with 1.1.7 we never faced this. I'm not sure if it is with 1.1.9+ or a MySQL version problem.
The system uses the informed chLastName to create usernames. If there are special characters in it, then the editor cannot change the username or the password, because they are returned after inclusion with corrupted characters.
The added user cannot login either, because the database does not recognize the username or password and then we cannot change the information.
Any ideas on how to solve this??
MySQL charset problems
Moderators: jmacgreg, michael, jheckman, barbarah, btbell, bdgregg, 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.
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.
3 posts
• Page 1 of 1
MySQL charset problems
by ramon » Fri Sep 16, 2005 12:07 pm
- ramon
- Posts: 905
- Joined: Wed Oct 15, 2003 6:15 am
- Location: Brasília/DF - Brasil
more MySQL Charset issues version 1.x
by ramon » Thu Sep 29, 2005 2:40 pm
Dear OJSers,
As the new MySQL has added the charset and collation features, I'm running into problems with updating a pretty old installation.
Since the upgrade is not working, what we are planning to do is install a 1.1.10 first, the migrate the table data. The problem is that the current installation is using something like iso (since the server has been updated, it may be latin1_swedish_ci, as it is the default).
Because we copied the data into a utf-8 database, as you may have guessed, lots of data is corrupted (since we use lots of special charcters) many user names, last names, even passwords are now unavailable.
The author index, which once worked, now does not list authors correctly, because it cannot recognize accented characters as one byte (instead they are 2-byte..), so our author index has either two sets of E's (with a hack we created to list accented letters as the original non-accented letter), or an author with the surname Évora is listed among the A's... (also, you should list the author index by last name first, since that's the way the letters link the authors...).
I guess what I'm looking for are suggestions to solve this problem... because I'm running out of ideas and time...
As the new MySQL has added the charset and collation features, I'm running into problems with updating a pretty old installation.
Since the upgrade is not working, what we are planning to do is install a 1.1.10 first, the migrate the table data. The problem is that the current installation is using something like iso (since the server has been updated, it may be latin1_swedish_ci, as it is the default).
Because we copied the data into a utf-8 database, as you may have guessed, lots of data is corrupted (since we use lots of special charcters) many user names, last names, even passwords are now unavailable.
The author index, which once worked, now does not list authors correctly, because it cannot recognize accented characters as one byte (instead they are 2-byte..), so our author index has either two sets of E's (with a hack we created to list accented letters as the original non-accented letter), or an author with the surname Évora is listed among the A's... (also, you should list the author index by last name first, since that's the way the letters link the authors...).
I guess what I'm looking for are suggestions to solve this problem... because I'm running out of ideas and time...
- ramon
- Posts: 905
- Joined: Wed Oct 15, 2003 6:15 am
- Location: Brasília/DF - Brasil
3 posts
• Page 1 of 1
Return to OJS Technical Support
Who is online
Users browsing this forum: Google [Bot] and 2 guests