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.

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.

Done. I hope someone has a look at my bug report soon.
bugs.limesurvey.org/view.php?id=9266