View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
03667Bug reportsSurvey takingpublic2009-09-22 00:58
Reporteradamzammit Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.85+ 
Fixed in Version1.85+ 
Summary03667: Multibyte data saved as question marks even when collation correct in database
Description

Even after following the Installation FAQ (http://docs.limesurvey.org/tiki-index.php?page=Installation+FAQ) both submitting multibyte language text at runtime and in survey setup resulted in question marks being stored in the database. When I tested the database by inserting multibyte text into the same fields using phpmyadmin, the data was stored correctly. When viewing the data added by phpmyadmin in limesurvey, it appeared correctly, but when it was saved it was overwritten with question marks.

To resolve this issue, I had to make the following modification to common.php:

=== modified file 'common.php'
--- common.php 2009-08-31 03:55:59 +0000
+++ common.php 2009-09-09 01:26:11 +0000
@@ -214,7 +214,8 @@
{
safe_die ("<br />Error: You need at least MySQL version 4.1 to run LimeSurvey. Your version:".$infoarray['version']);
}

  • @$connect->Execute("SET CHARACTER SET 'utf8'"); //Checked
  • @$connect->Execute("SET CHARACTER SET 'utf8'"); //Checked
  • @$connect->Execute("set names 'utf8'");
    }
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)7253
I will donate to the project if issue is resolved
BrowserFirefox 3
Database type & versionmySQL 5.0.51a-24+lenny1
Server OS (if known)Debian 5 (lenny)
Webserver software & version (if known)Apache 2.2.9
PHP Version5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2

Users monitoring this issue

adamzammit

Activities

c_schmitz

c_schmitz

2009-09-16 01:00

administrator   ~09570

Thank you very much.

Issue History

Date Modified Username Field Change
2009-09-09 03:55 adamzammit New Issue
2009-09-09 03:55 adamzammit Status new => assigned
2009-09-09 03:55 adamzammit Assigned To => user372
2009-09-09 03:55 adamzammit Build Number => 7253
2009-09-09 03:55 adamzammit Browser => Firefox 3
2009-09-09 03:55 adamzammit Database & DB-Version => mySQL 5.0.51a-24+lenny1
2009-09-09 03:55 adamzammit Operating System (Server) => Debian 5 (lenny)
2009-09-09 03:55 adamzammit Webserver => Apache 2.2.9
2009-09-09 03:55 adamzammit PHP Version => 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2
2009-09-09 03:57 adamzammit Issue Monitored: adamzammit
2009-09-10 16:04 c_schmitz Assigned To user372 => c_schmitz
2009-09-16 01:00 c_schmitz Note Added: 09570
2009-09-16 01:00 c_schmitz Status assigned => resolved
2009-09-16 01:00 c_schmitz Fixed in Version => 1.85+
2009-09-16 01:00 c_schmitz Resolution open => fixed
2009-09-22 00:58 c_schmitz Status resolved => closed
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking