Welcome to the LimeSurvey Community Forum

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

Change database collation from utf8mb4 to utf8 when activating survey for table

  • bigrock
  • bigrock's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 8 months ago - 6 years 8 months ago #157964 by bigrock
Change database collation from utf8mb4 to utf8 when activating survey for table was created by bigrock
Hi

I am hoping someone can help me.


I cant upgrade my MySQL as I have too many other sites on the sever.


Is there a way that I can change the database collation for the tables that are created when a survey is activated from utf8mb4 to utf8?

The error was:

'CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1273 Unknown collation: \'utf8mb4_bin\'.

When trying to activate the survey.


Thanks

Mark
Last edit: 6 years 8 months ago by bigrock. Reason: More info
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 7 months ago #158020 by DenisChenu
Replied by DenisChenu on topic Change database collation from utf8mb4 to utf8 when activating survey for table
Except with hacking LimeSurvey code : i didn't see. And you have bug after when user use emoji …
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • bigrock
  • bigrock's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 7 months ago #158061 by bigrock
Replied by bigrock on topic Change database collation from utf8mb4 to utf8 when activating survey for table
Hi Denis

Thanks for your reply.

Do you have any idea where in the code, I have serached with no luck?

Thanks

Mark
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 7 months ago #158128 by DenisChenu
Replied by DenisChenu on topic Change database collation from utf8mb4 to utf8 when activating survey for table
Somewhere in common_helper / activate function
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • bigrock
  • bigrock's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 7 months ago #158131 by bigrock
Replied by bigrock on topic Change database collation from utf8mb4 to utf8 when activating survey for table
Excellent thank you very much, that sorted it
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source