View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
08918Bug reportsStatisticspublic2014-04-04 10:26
Reportergwdger Assigned Toc_schmitz  
PriorityurgentSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08918: The answer appear in the form of signs
Description

The answer of Question type - Short free text & Long free text appear in the form of signs like: "????"
note:
that the survey and question are in Arabic language
and the answer is in Arabic language
if someone has to answer in English, no problem .and show his answering naturally
that means the problem is in the answers of the Arabic language only .

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)Version 2.05 + Build 140320
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & version5.5.32
Server OS (if known)Linux boscustweb0703.eigbox.net 3.2.52 #1 SMP Thu Nov 14 15:42:11 EST 2013 x86_64
Webserver software & version (if known)Linux boscustweb0703.eigbox.net 3.2.52 #1 SMP Thu Nov 14 15:42:11 EST 2013 x86_64
PHP VersionVersion 5.3.13

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-03-29 15:35

administrator   ~29600

Where do you they appear like this exactly?

c_schmitz

c_schmitz

2014-03-29 16:26

administrator   ~29602

This is a problem of your database collation - please refer to the forum thread. Also check out: https://manual.limesurvey.org/Troubleshooting#Texts_that_were_entered_by_the_participant_appear_as_question_marks_in_the_results

c_schmitz

c_schmitz

2014-03-29 16:32

administrator   ~29603

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14087

gwdger

gwdger

2014-03-29 18:33

reporter   ~29607

Unresolved
I tried to do this :SQL command on database similar to what is found here:

https://manual.limesurvey.org/Troubleshooting#Texts_that_were_entered_by_the_participant_appear_as_question_marks_in_the_results

but I did not succeed
note :
all of the tables encoding utf8 COLLATE utf8_unicode_c, but there are only 3 or 4 are encoding latin1_swedish_ci

c_schmitz

c_schmitz

2014-03-29 18:36

administrator   ~29608

Please do not re-open this issue. If you have more questions please use the forums. Thank you.

gwdger

gwdger

2014-03-29 20:21

reporter   ~29614

Why closed the bug I did not find Solve for this problem yet
  I wrote about this problem before on the forums, but there is no Solve also

DenisChenu

DenisChenu

2014-04-01 08:45

developer   ~29633

Hi,

2 think :
@gwdger : i tell you the SQL line to use : https://www.limesurvey.org/en/forum/development/96474-the-answer-appear-in-the-form-of-signs?q=/en/forum/development/96474-the-answer-appear-in-the-form-of-signs&start=10#106910

@Carsten : i have the same issue with an existing version, seems installation and update don't really fix this issue : maybe we can add this to 'checkdataintegrity' ?

c_schmitz

c_schmitz

2014-04-04 10:26

administrator   ~29657

2.05+ Build 140404 released.

Related Changesets

LimeSurvey: master fa2f02c7

2014-03-29 15:33:13

c_schmitz

Details Diff
Fixed issue 08918: Paticipant responses contain only question marks Affected Issues
08918
mod - application/helpers/database_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-03-29 15:24 gwdger New Issue
2014-03-29 15:24 gwdger File Added: survey_archive_417979.lsa
2014-03-29 15:35 c_schmitz Note Added: 29600
2014-03-29 15:35 c_schmitz Assigned To => c_schmitz
2014-03-29 15:35 c_schmitz Status new => feedback
2014-03-29 16:26 c_schmitz Note Added: 29602
2014-03-29 16:26 c_schmitz Status feedback => closed
2014-03-29 16:26 c_schmitz Resolution open => unable to reproduce
2014-03-29 16:30 c_schmitz Status closed => assigned
2014-03-29 16:32 c_schmitz Changeset attached => LimeSurvey master fa2f02c7
2014-03-29 16:32 c_schmitz Note Added: 29603
2014-03-29 16:32 c_schmitz Resolution unable to reproduce => fixed
2014-03-29 16:34 c_schmitz Status assigned => resolved
2014-03-29 16:34 c_schmitz Fixed in Version => 2.05+
2014-03-29 18:33 gwdger Note Added: 29607
2014-03-29 18:33 gwdger Status resolved => feedback
2014-03-29 18:33 gwdger Resolution fixed => reopened
2014-03-29 18:36 c_schmitz Note Added: 29608
2014-03-29 18:36 c_schmitz Status feedback => resolved
2014-03-29 18:36 c_schmitz Resolution reopened => fixed
2014-03-29 20:21 gwdger Note Added: 29614
2014-04-01 08:45 DenisChenu Note Added: 29633
2014-04-04 10:26 c_schmitz Note Added: 29657
2014-04-04 10:26 c_schmitz Status resolved => closed