Welcome to the LimeSurvey Community Forum

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

character encoding issue after migrating server

  • limesurvey_asker
  • limesurvey_asker's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 1 week ago #212078 by limesurvey_asker
character encoding issue after migrating server was created by limesurvey_asker
Hi guys,

the  Character is showing up in my questions in the survey after migrating limesurvey. Sometimes they replace ä ü ö, but sometimes they just appear instead of a space character. the migration was done using the export "save whole database" feature. So maybe the problem lies when this whole database was loaded into the new mysql database? that at this time the enkoding did go wrong? If I look at the stored answers by logging into the database, everything looks fine.

old System:
MySQL 5.7
Php version 5.X
limesurvey version 3.20.2+191119

new System:
MySQL 5.7
PHP Version 7.4
limesurvey version 3.25.0+201117

Any tipps? Thanks in advance,
limesurvey_asker
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 1 week ago #212086 by holch
You have postet this already, and you have received answers. Why posting it again???

Continue here: forums.limesurvey.org/forum/installation...oving-to-a-new-serve

Help us to help you!
  • Provide your LS version and where it is installed (own server, uni/employer, SaaS hosting, etc.).
  • Always provide a LSS file (not LSQ or LSG).
Note: I answer at this forum in my spare time, I'm not a LimeSurvey GmbH employee.
The topic has been locked.
  • limesurvey_asker
  • limesurvey_asker's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 1 week ago - 4 years 1 week ago #212092 by limesurvey_asker
Replied by limesurvey_asker on topic character encoding issue after migrating server
I was not the topic author on that old post. I did not receive answers (meaning solutions / multiple replies), I received one reply with a workaround. That's why I opened this post, so maybe someone knows how to fix the root cause of this. Because I am not sure if I might have to migrate multiple times.

I think it might have something to do with MySQL collation?
Last edit: 4 years 1 week ago by limesurvey_asker.
The topic has been locked.
Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose