Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Response Data show "????" when we enter Chinese character in the Long Free Text

  • pravpraji
  • pravpraji's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months ago #167448 by pravpraji
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
Attachments:
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 11 months ago #167451 by Joffm
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

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • pravpraji
  • pravpraji's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months ago - 5 years 11 months ago #167454 by pravpraji
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.
Last edit: 5 years 11 months ago by pravpraji.
The topic has been locked.
  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 11 months ago #167456 by Joffm
Hi,

the database doesn't seem to be MySQL.

What is it?

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • pravpraji
  • pravpraji's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 11 months ago - 5 years 11 months ago #167457 by pravpraji
Database we are using is MS SQL SERVER.
Last edit: 5 years 11 months ago by pravpraji.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 11 months ago #167466 by holch
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.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
5 years 11 months ago #167543 by c_schmitz
What's the exact configuration here?
Does only the database run on MSSQL and the webserver on Linux?

Best regards

Carsten Schmitz
LimeSurvey project leader
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose