View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
03667 | Bug reports | Survey taking | public | 2009-09-09 03:55 | 2009-09-22 00:58 |
Reporter | adamzammit | Assigned To | c_schmitz | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.85+ | ||||
Fixed in Version | 1.85+ | ||||
Summary | 03667: 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'
| ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 7253 | ||||
I will donate to the project if issue is resolved | |||||
Browser | Firefox 3 | ||||
Database type & version | mySQL 5.0.51a-24+lenny1 | ||||
Server OS (if known) | Debian 5 (lenny) | ||||
Webserver software & version (if known) | Apache 2.2.9 | ||||
PHP Version | 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 | ||||
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 |