Responses stored as messy codes in MS SQL server

More
4 years 2 months ago - 4 years 2 months ago #94032 by ldhf5237
ldhf5237 created the topic: Responses stored as messy codes in MS SQL server
: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: 4 years 2 months ago by ldhf5237. Reason: Missed the database type

Please Log in to join the conversation.

More
4 years 2 months ago #94073 by luayessa
luayessa replied the topic: Responses stored as messy codes in MS SQL server
Check the SQL SERVER character set settings.
It should be utf-8
The following user(s) said Thank You: ldhf5237

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now