View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13904 | Bug reports | [All Projects] Survey design | public | 2018-07-25 07:24 | 2019-02-19 09:28 |
Reporter | efingdmi | Assigned To | markusfluer | ||
Priority | high | Severity | major | ||
Status | assigned | Resolution | open | ||
Product Version | 3.13.x | ||||
Target Version | Fixed in Version | ||||
Summary | 13904: Japanese characters get replaced with '?' | ||||
Description | Settings -> Text elements (Welcome message, Description, End, Privacy...) If I enter a japanese text here, it will be replaced with a lot of questionmarks. This happens only in the editor windows on this page. Everything is fine e.g. when creating questions. | ||||
Steps To Reproduce | Settings -> Text elements (Welcome message, Description, End, Privacy...) -> enter japanese characters | ||||
Tags | No tags attached. | ||||
Complete LimeSurvey version number (& build) | 3.13.2+180709 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | FF, Chrome | ||||
Database & DB-Version | MS SQL Server 2012 | ||||
Server OS (if known) | Windows Server 2012 R2 64Bit | ||||
Webserver software & version (if known) | Apache Apache 2.4.33 (64bit) | ||||
PHP Version | PHP 7.2.6 (64bit) | ||||
related to | 14545 | resolved | DenisChenu | Unable to reset menu entries with MSSQL |
related to | 13989 | new | Russian characters are getting displayed as question marks |
limesurvey_survey_116537.lss (13,726 bytes) |
|
This also occurs if someone answers in Japanese. So the results are not usable :( |
|
Have you used the language before with this installation of LimeSurvey? Did I get it right. The Umfragetitel is always shown correctly? Any other fields, which are showing the correct content after saving the form? Apache and PHP are running on Windows, right? |
|
No it was the first time we tried Japanese characters. Maybe some probem with mssql? I had no chance to test it with mysql, sorry :( |
|
Can you check what admin theme is set? Configuration -> Themes -> Admin themes. There is a admin theme To me it looks more like an issue which LS only has when interacting with MS SQL. |
|
I will try. |
|
No change when switching to the NOTO default template. Version 2.62.2+170203 is working perfect in the same database. Even with the SeaGreen template. Maybe this helps. |
|
markus, I'd like your point of view on this problem |
|
anything I could do to help here? |
|
still nothing? I searched a lot, compared it with 2.62.2 but I did not find the solution :( |
|
Surely related to DB (MS SQL Server 2016) and maybe Server OS (Windows Server 2012 R2 64Bit) We already use nvarchar and ntext for MSSQL :https://stackoverflow.com/a/22955415/2239406 About the "how to find when this issue happen" Until find the broken release. |
|
Hi, and thanks for the reply. Just to clarify: I should set up a secound system again (2.62) and upgrade it step by step? Then I will try it :) |
|
Can not reproduce on 3.15.5 version on Windows server 2016 (IIS) + php 7.2.9 + sqlsrv + msodbcsql17.dll + SQLServer 12.00.5590 |
|
I will try this asap :) |
|
stil the same :( |
|
It is working in 2.27.3, but not in 3.x Difference I found in application\core\db\MssqlSchema,php |
|
Both versions have the line: $this->columnTypes['text'] = 'nvarchar(max)'; |
|
This part : https://github.com/LimeSurvey/LimeSurvey/blob/master/application/core/db/MssqlSchema.php#L50-L66 Here is the same function used in 2.73 : https://github.com/SondagesPro/LimeSurvey-SondagesPro/blob/2.73/framework/db/schema/CDbSchema.php#L371-L383 It's seems to update ONLY for pk, then in think it's a difference in your MSSQL server |
|
hmm true. Can't find a difference. I'm using the same databse for the two versions, also the same settings. |
|
Is the database collation the same? |
|
@markusfluer : mssql issue somewhere And this line : https://github.com/LimeSurvey/LimeSurvey/blob/b96ff7cba0ecff5b80a912f762903bc12c6c4ce0/application/core/db/MssqlSchema.php#L19 or https://github.com/LimeSurvey/LimeSurvey/blob/b96ff7cba0ecff5b80a912f762903bc12c6c4ce0/application/core/db/MssqlSchema.php#L11 |
|
@markusfluer everything is the same but the LS Version, and the table prefix, lime26 and lime3, so there shouldn't be the problem. |
|
it is a MS SQL Server 2012, can't change it in the Bug report |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2018-07-25 07:24 | efingdmi | New Issue | |
2018-07-25 07:24 | efingdmi | File Added: before.png | |
2018-07-25 07:24 | efingdmi | File Added: after.png | |
2018-07-25 07:24 | efingdmi | File Added: questions.png | |
2018-07-25 07:24 | efingdmi | File Added: limesurvey_survey_116537.lss | |
2018-08-20 09:41 | efingdmi | Note Added: 48823 | |
2018-08-22 12:26 | LouisGac | Priority | none => high |
2018-08-22 12:26 | LouisGac | Severity | minor => major |
2018-08-22 13:29 | jelo | Relationship added | related to 13989 |
2018-08-22 14:43 | jelo | Note Added: 48853 | |
2018-08-23 08:07 | efingdmi | Note Added: 48857 | |
2018-08-23 09:59 | jelo | Note Added: 48859 | |
2018-08-23 10:39 | efingdmi | Note Added: 48861 | |
2018-08-23 10:44 | efingdmi | Note Added: 48862 | |
2018-08-28 11:21 | LouisGac | Assigned To | => markusfluer |
2018-08-28 11:21 | LouisGac | Status | new => assigned |
2018-08-28 11:21 | LouisGac | Note Added: 48888 | |
2018-09-10 13:49 | efingdmi | Note Added: 48999 | |
2018-11-30 14:45 | efingdmi | Note Added: 49856 | |
2018-12-18 00:33 | DenisChenu | Note Added: 49980 | |
2018-12-18 14:05 | efingdmi | Note Added: 49986 | |
2019-01-09 12:04 | DenisChenu | Note Added: 50132 | |
2019-01-15 10:21 | efingdmi | Note Added: 50206 | |
2019-01-21 13:13 | efingdmi | File Added: japanese.png | |
2019-01-21 13:13 | efingdmi | Note Added: 50286 | |
2019-02-12 17:37 | efingdmi | Note Added: 50533 | |
2019-02-12 17:46 | efingdmi | Note Added: 50535 | |
2019-02-13 09:36 | DenisChenu | Note Added: 50537 | |
2019-02-13 09:55 | efingdmi | Note Added: 50540 | |
2019-02-15 13:45 | markusfluer | Note Added: 50568 | |
2019-02-15 16:43 | DenisChenu | Note Added: 50577 | |
2019-02-17 12:05 | efingdmi | Note Added: 50588 | |
2019-02-18 15:39 | efingdmi | Note Added: 50608 | |
2019-02-18 16:01 | DenisChenu | Database & DB-Version | MS SQL Server 2016 => MS SQL Server 2012 |
2019-02-19 09:28 | DenisChenu | Relationship added | related to 14545 |