- Posts: 24
- Thank you received: 0
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
- Topic Author
- Offline
- Junior Member
Less
More
9 years 5 months ago #112887
by Anurag01
Chinese and Japanese characters support in case of MS SQL Server was created 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.
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.
Attachments:
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10611
- Thank you received: 3690
9 years 5 months ago #112895
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Chinese and Japanese characters support in case of MS SQL Server
Please
file a bug report
and...
- Give as much information as possible.
- Provide step-by-step instructions how to reproduce the problem.
- Provide screenshots and/or a sample survey.
- 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
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 24
- Thank you received: 0
9 years 5 months ago #112914
by Anurag01
Replied by Anurag01 on topic Chinese and Japanese characters support in case of MS SQL Server
Done. I hope someone has a look at my bug report soon.
bugs.limesurvey.org/view.php?id=9266
bugs.limesurvey.org/view.php?id=9266
The topic has been locked.