- Posts: 3
- Thank you received: 0
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
- Topic Author
- Offline
- New Member
Less
More
6 years 20 hours ago #167448
by pravpraji
Response Data show "????" when we enter Chinese character in the Long Free Text was created 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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12881
- Thank you received: 3965
6 years 19 hours ago #167451
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Response Data show "????" when we enter Chinese character in the Long Free Text
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
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
Attachments:
The topic has been locked.
- pravpraji
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
6 years 18 hours ago - 6 years 18 hours ago #167454
by pravpraji
Replied by pravpraji on topic Response Data show "????" when we enter Chinese character in the Long Free Text
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.
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.
Attachments:
Last edit: 6 years 18 hours ago by pravpraji.
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12881
- Thank you received: 3965
6 years 18 hours ago #167456
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Response Data show "????" when we enter Chinese character in the Long Free Text
Hi,
the database doesn't seem to be MySQL.
What is it?
Joffm
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
6 years 18 hours ago - 6 years 18 hours ago #167457
by pravpraji
Replied by pravpraji on topic Response Data show "????" when we enter Chinese character in the Long Free Text
Database we are using is MS SQL SERVER.
Last edit: 6 years 18 hours ago by pravpraji.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11637
- Thank you received: 2737
6 years 14 hours ago #167466
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Response Data show "????" when we enter Chinese character in the Long Free Text
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.
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
- Offline
- LimeSurvey GmbH Employee
Less
More
- Posts: 301
- Thank you received: 84
5 years 11 months ago #167543
by c_schmitz
Best regards
Carsten Schmitz
LimeSurvey project leader
Replied by c_schmitz on topic Response Data show "????" when we enter Chinese character in the Long Free Text
What's the exact configuration here?
Does only the database run on MSSQL and the webserver on Linux?
Does only the database run on MSSQL and the webserver on Linux?
Best regards
Carsten Schmitz
LimeSurvey project leader
The topic has been locked.