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 |