Welcome to the LimeSurvey Community Forum

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

Responses stored as messy codes in MS SQL server

  • ldhf5237
  • ldhf5237's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 11 months ago - 10 years 11 months ago #94032 by ldhf5237
:dry:
I did a query in lime survey database and found non-english responses are stored as messy codes in database (SQL SERVER 2008). But the response shows correct when I export them from Lime Survey. Why ? :ohmy:
Last edit: 10 years 11 months ago by ldhf5237. Reason: Missed the database type
The topic has been locked.
More
10 years 11 months ago #94073 by luayessa
Check the SQL SERVER character set settings.
It should be utf-8
The following user(s) said Thank You: ldhf5237
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose