Hi Nitin, Have you tried the steps here -> https://bugs.launchpad.net/mahara/+bug/1912492/comments/1
Cheers Robert ** Information type changed from Private Security to Public -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: mahara-contributors https://bugs.launchpad.net/bugs/2003190 Title: Not able to change Mahara collation from utf8_bin to utf8mb4_unicode_ci Status in Mahara: Incomplete Bug description: I am using Mahara version 22.04, Mahara recommending to change its DB collation. Mysql version - 5.7 PHP version - 7.4 Using PHPMyAdmin & manually, through the notepad editor(manually replacing) both methods are not working. Please suggest how can I change it from utf8_bin to utf8mb4_unicode_ci. - Using PHPMyAdmin It is not working to change the collation for MySQL table columns. - Using editor During DB import it shows multiple errors. like - Foreign Key constraint errors and more Please suggest To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/2003190/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
