The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: Responses stored as messy codes in MS SQL server

Responses stored as messy codes in MS SQL server 2 months 1 day ago #94032

  • ldhf5237
  • ldhf5237's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
: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: 2 months 1 day ago by ldhf5237. Reason: Missed the database type
The administrator has disabled public write access.

Responses stored as messy codes in MS SQL server 2 months 21 hours ago #94073

  • luayessa
  • luayessa's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 22
  • Thank you received: 1
  • Karma: 0
Check the SQL SERVER character set settings.
It should be utf-8
The administrator has disabled public write access.
The following user(s) said Thank You: ldhf5237
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.440 seconds
Donation Image