Welcome, Guest
Username: Password: Remember me

TOPIC: Responses stored as messy codes in MS SQL server

Responses stored as messy codes in MS SQL server 1 year 7 months ago #94032

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

Responses stored as messy codes in MS SQL server 1 year 7 months 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
Moderators: ITEd
Time to create page: 0.096 seconds
Donation Image