11916: Czech languague sorting, czech languague import - LimeSurvey bugs and feature requests

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update
11916	Bug reports	Ergonomy	public	2016-11-16 15:10	2016-11-16 18:15

Reporter	jelen1	Assigned To	c_schmitz
Priority	none	Severity	partial_block
Status	closed	Resolution	won't fix
Product Version	2.54

Summary	11916: Czech languague sorting, czech languague import
Description	There are some problems with czech languague. Page /index.php/admin/globalsettings# subpage "Jazyk" (Languague) show wrong sorting order of languagues. Names of languagues, included czech special characters, are sorded as in english, not as in czech. For example: Languaue "Čeština" is sorted after "Zulština", but right order of letter "Č" is betveen C and D. Another sort order problem is in index.php/admin/survey/sa/listsurveys page. There is "Č" letter sorted as "C" ("Č" started names of surveys are mixed between "C" started names, but not after all of them, before "D"). Thirth problem starts during import of participants. Surname of first participant in file was "Kopřiva". Application returned error: Internal Server Error CDbCommand nemohl vykonat SQL příkaz: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Steps To Reproduce	Use czech languague setting, try create 3 surveys, named Celer Čajíček Datle Those three names mus be ordered as is above. But it is sorted another way. In languague setting look to languague list. Čeština mus be sorted between "C..." and "D..." languagues
Additional Information	All problems are probably result of wrong setting od character page in database.
Tags	No tags attached.

Bug heat	2
Complete LimeSurvey version number (& build)	2.55.3+161111
I will donate to the project if issue is resolved	No
Browser	Mozzilla, IE
Database type & version	mysql Ver 15.1 Distrib 10.0.27-MariaDB, for Linux (x86_64) using readline 5.1
Server OS (if known)	3.10.0-427.10.1.lve1.4.7.el7.x86_64 #1 SMP Sat Apr 2 12:09:46 EDT 2016 x86_64
Webserver software & version (if known)	Apache/2.4.23 (Unix) OpenSSL/1.0.1e-fips
PHP Version	5.5.38

User List	There are no users monitoring this issue.

Date Modified	Username	Field	Change
2016-11-16 15:10	jelen1	New Issue
2016-11-16 18:15	c_schmitz	Assigned To	=> c_schmitz
2016-11-16 18:15	c_schmitz	Status	new => closed
2016-11-16 18:15	c_schmitz	Resolution	open => won't fix
2016-11-16 18:15	c_schmitz	Note Added: 42001

View Issue Details

Users monitoring this issue

Activities

Issue History

c_schmitz 2016-11-16 18:15 administrator ~42001	The sorting is determined by the database in some cases and other cases by the application. Both are language-agnostic and the effort to implement it would be too big, sorry.