View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
12026Bug reportsOtherpublic2017-09-28 16:02
ReporterKaiS Assigned Tomarkusfluer 
PrioritynoneSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.57.x 
Summary12026: 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.
Also install a mssql Server on a Windows Server 2012 r2.
Then install Apache2 and all needed modules for LimeSurvey (I used: php7.0-xml php7.0-mbstring php-gd php-ldap php-zip php-imap php-sybase)
Then install LimeSurvey and connect it to the mssql Database.
Now create a new Survey and insert some mutated vowels like ä, ö, ü
When you save your entry the Webpage should display Chinese chars and your entrys should also be saved in Chinese inside your mssql database.

Additional Information

I used an Domain account to log into the mssql database.
The Databased collation is: Latin1_General_CI_AS.

My freetds config(/etc/freetds/freedts.conf):

A typical Microsoft server

[sql201201]
host = sql201201.my.domain.de
port = 1433
tds version = 8.0
date format = %Y-%m-%d %H:%M:%S.%z
client charset = utf8

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)2.57.1+161205
I will donate to the project if issue is resolvedNo
BrowserInternet Explorer, FireFox
Database type & versionmssql 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 VersionPHP 7.0.8-0ubuntu0.16.04.3

Users monitoring this issue

fvanderstarre

Activities

c_schmitz

c_schmitz

2017-06-13 14:20

administrator   ~43893

Do you still have the issue?

c_schmitz

c_schmitz

2017-09-28 16:02

administrator   ~44518

Closed due to missing feedback.

Issue History

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