Support Forums
ATutor Bug Reports
Problem with russian letters "ш" and "И"
You must be signed-in to post.
| Author | Subject | |
|---|---|---|
| Page: 1 | ||
NickSlavsky Screen.doc 
| Subject: Problem with russian letters "ш" and "И" |  |
| Hey guys, i'm using atutor 1.6.4 with russian translation pack in a small school (see details below). everything works OK with the encoding except for russian letters "ш" (lower case) and "И" (upper case). Please see the attached screen shot for the details of how the lower case "ш" is displayed in a last name of one student. It happens only with the aforementioned case, i.e. with "ш" (lower case) and "И" (upper case) and never vice versa. I'm not really into the php development but from what i figure out it has to do with the way the character set is defined in the database. Is there any simple way i can fix this? for upper case И i have a workaround: i use the lower case instead which works to an extent. but i cannot use upper case Ш all the time... Database: 1.57 MB Disk Usage: 0.46 MB Courses: 15 Users: 16 ATutor Version: 1.6.4. Check Latest Version. PHP Version: 5.2.11 MySQL Version: 5.0.87-community-log OS: Linux 2.6.18-164.10.1.el5 Posted: 2010-02-16 08:50:22 | ||
 | ||
greg | Subject: Re: Problem with russian letters | |
| I've noted this in the bug tracker. Can you confirm whether this is occurring in other places in ATutor, or only this one screen. www.atutor.ca/atutor/mantis/view.php?id=4137 Posted: 2010-02-16 10:53:10 | ||
| ||
| NickSlavsky | Subject: Re: Problem with russian letters | |
| thanks! i also noticed that this occurs in the gradebook too. test case to reproduce: 1. create a custom grade scale 2. enter marks as words (e.g. excellent, good etc) but in russian: хорошо 3. the lower case ш will be distorted. another place: the course names. if you use these letters in the course names, the same behavior is observed. from what i have seen on forums the problem is as follows: all the tables are in unicode utf8, but the parameter character_set_results is set to cp1251. which means that the database sends the utf8 encoded string in another charset. one of the possible solutions would be to send mysql query set names utf8 mysql_query("SET NAMES 'utf8'"); mysql_query("SET collation_connection = 'UTF-8_general_ci'"); mysql_query("SET collation_server = 'UTF-8_general_ci'"); mysql_query("SET character_set_client = 'UTF-8'"); mysql_query("SET character_set_connection = 'UTF-8'"); mysql_query("SET character_set_results = 'UTF-8'"); mysql_query("SET character_set_server = 'UTF-8'"); Posted: 2010-02-17 05:17:58 | ||
| ||
| NickSlavsky | Subject: Re: Problem with russian letters | |
| Hi greg! check out the thread www.atutor.ca/view/3/19643/1.html Harris pointed me to the file where the connection is set and i added the above query. so the issue with the letters "ш" and "И" is gone now. i believe you should add this query too to make Atutor fully UTF compliant... Posted: 2010-02-27 04:04:29 | ||
| ||
| Page: 1 | ||
You must be signed-in to post.