Welcome to the LimeSurvey Community Forum

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

Chinese and Japanese characters support in case of MS SQL Server

  • Anurag01
  • Anurag01's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #112887 by Anurag01
Limesurvey has this peculiar issue with SQL Server databases. When Chinese or Japanese language is added to a survey, upon saving basic information, questions or answers, the characters are not stored properly in database and displayed in a funny way (see attachment) when a user opens the survey.

This has been the case since, at least, v1.92+ where I fixed the issue by converting many text/varchar columns in database into their N-datatypes (Nvarchar, Ntext, etc.) for getting Unicode support. I also had to "hack" a lot of core files and replace datatypes to match the N-datatypes.

Now we have upgraded to v2.05, but the issue still exists. We cannot imagine doing all that dirty hacking all over again. Is there an easy way to get Limesurvey plus SQL Server to support Chinese/Japanese characters?

Thanks and regards.

The topic has been locked.
  • tpartner
  • tpartner's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 5 months ago #112895 by tpartner
Please file a bug report and...
  1. Give as much information as possible.
  2. Provide step-by-step instructions how to reproduce the problem.
  3. Provide screenshots and/or a sample survey.
  4. Post the link to the bug here so we can follow the progress.

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
  • Anurag01
  • Anurag01's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
9 years 5 months ago #112914 by Anurag01
Done. I hope someone has a look at my bug report soon.
bugs.limesurvey.org/view.php?id=9266
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose