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

More
3 months 3 weeks ago - 3 months 3 weeks ago #157964 by bigrock
bigrock created the topic: Change database collation from utf8mb4 to utf8 when activating survey for table
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: 3 months 3 weeks ago by bigrock. Reason: More info

Please Log in to join the conversation.

More
3 months 2 weeks ago #158020 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 months 2 weeks ago #158061 by bigrock
bigrock replied the 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

Please Log in to join the conversation.

More
3 months 2 weeks ago #158128 by DenisChenu
DenisChenu replied the 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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 months 2 weeks ago #158131 by bigrock
bigrock replied the topic: Change database collation from utf8mb4 to utf8 when activating survey for table
Excellent thank you very much, that sorted it

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!