Community Forums

ATutor Bug Reports

Problem with russian letters "ш" and "И"


You must be signed-in to post.

AuthorSubject
 
Page: 1
NickSlavsky

Avatar for NickSlavsky
Screen.doc

Attachment: Screen.doc
Subject: Problem with russian letters "ш" and "И"Quote this post in your reply
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

Avatar for greg
Subject: Re: Problem with russian lettersQuote this post in your reply
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

Avatar for NickSlavsky
Subject: Re: Problem with russian lettersQuote this post in your reply
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

Avatar for NickSlavsky
Subject: Re: Problem with russian lettersQuote this post in your reply
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.

Related Articles