View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 12026 | Bug reports | Other | public | 2017-01-03 12:17 | 2017-09-28 16:02 |
| Reporter | KaiS | Assigned To | |||
| Priority | none | Severity | partial_block | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 2.57.x | ||||
| Summary | 12026: Can't save german sepcial chars in mssql | ||||
| Description | Hello, I am using an Ubuntu 16.04 Server and installed Apache 2 with LimeSurvey. I am using a mssql Server for storing my data. The installation worked fine and without problems. When I create a new survey and try to type mutated vowels (in german called "Umlaute") like ä, ö, ü and try to save the survey, it gets saved as Chinese chars. For Example a "ä" is saved as ꓃ or a "ö" is saved as 뛃. When I try to insert the chars manual via the Microsoft SQL Server Management Studio, using a query all works fine. I can also save the chars using freetds directly on the LimeSurvey Server. I already tryed to set the default char set for Apache and freetds to utf-8 but nothing changed. It seems so that there is a problem caused by LimeSurvey while saving the data in the database. Also when I create a new Survey the default E-Mail Message for participants is completly converted to chinese. First line of the e-mail: 뿫ꦺꛪꪋꛮꮪꯪ몪껨ꪯ뫮ꪪ믪ꪢꫪ꺫껮. | ||||
| Steps To Reproduce | Install Ubuntu 16.04 Server and set the Default language to German. | ||||
| Additional Information | I used an Domain account to log into the mssql database. My freetds config(/etc/freetds/freedts.conf): A typical Microsoft server[sql201201] | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 2.57.1+161205 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Internet Explorer, FireFox | ||||
| Database type & version | mssql server 2012 v. 11 0 6020 0 | ||||
| Server OS (if known) | Ubuntu 16.04, Windows Server 2012 r2 | ||||
| Webserver software & version (if known) | Apache/2.4.18 2016-07-14T12:32:26 | ||||
| PHP Version | PHP 7.0.8-0ubuntu0.16.04.3 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-01-03 12:17 | KaiS | New Issue | |
| 2017-01-12 12:14 | c_schmitz | Assigned To | => markusfluer |
| 2017-01-12 12:14 | c_schmitz | Status | new => assigned |
| 2017-06-13 14:20 | c_schmitz | Note Added: 43893 | |
| 2017-06-13 14:20 | c_schmitz | Status | assigned => feedback |
| 2017-06-13 14:22 | c_schmitz | Product Version | => 2.57.x |
| 2017-06-15 11:42 | fvanderstarre | Issue Monitored: fvanderstarre | |
| 2017-09-28 16:02 | c_schmitz | Status | feedback => closed |
| 2017-09-28 16:02 | c_schmitz | Resolution | open => unable to reproduce |
| 2017-09-28 16:02 | c_schmitz | Note Added: 44518 | |
| 2021-08-04 06:22 | guest | Bug heat | 2 => 4 |