Hi All,


We have created a multilingual survey on Lime Survey version : 2.67.3+170728.


while downloading responses we noticed that in Long Free Text File the response data show "??????" instead of the other language character such as Chinese or Korean.


We need your help to fix this issue as soon as possible. since the user is taking part in the survey.


Please find the attachment for your references

Hi, i have no idea, but
a. did you check the data in the database (by phpMyAdmin, TOAD, or similar tools)?
b. does the setting of language affect it?

In "Show answer"


In "export"


Your screenshot looks like the "Show answers" table, not like an export.
Or what does "downloading responses" mean?

Joffm

Thank you for your reply.


The response is also saved like "??????" in the table on the limesurvey database instead of the Chinese character unicode.

This behavior is happening only on the user response . The question and answer configuration can able to accept multiple language characters.

Hi,

the database doesn't seem to be MySQL.

What is it?

Joffm

Database we are using is MS SQL SERVER.

Bam! there you go! Don't ever use MS SQL Server...

OK, now on a more serious note: I personally would always go with LAMP (Linux, Apache, MySQL, PHP) for Limesurvey, just because this is the platform most developers work on and most people test on. On other combinations the risk of problems like this is a lot higher, because they developers depend mainly on feedback and bug-reports from the users.

Most probably it has to do with the character set, which can be tricky. Maybe reporting this via the bug tracker will bring this to the developers attention quicker.

What's the exact configuration here?
Does only the database run on MSSQL and the webserver on Linux?