Joomla Templates Club 406,261 posts

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#948703

Hi You can try Akeeba admin tool extension from JED By this extension you can easily change the DB collation to UTF-8gneral ci .

http://prntscr.com/bre857
Take a full backup of site before apply changes .
Hope it helps .

[pressmar Friend pressmarJoin date: March 2008Posts: 119Downloads:14Uploads:51 Thanks: 25 Thanked: 4 times in 1 posts]

#948709

Hi Pankaj,

thanks for that advise. I tried it, the tool say it changed it, i did the repair but nothing changed in the database. maybe the import error on the productions server helps further:

CREATE TABLE IF NOT EXISTS joomla_admintools_acl (
user_id bigint( 20 ) unsigned NOT NULL ,
permissions longtext COLLATE utf8mb4_unicode_ci
) ENGINE = MYISAM DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#948710

Hi
This is work normally . If its not working for you can try below tips
https://www.a2hosting.com/kb/cpanel/cpanel-database-features/changing-the-mysql-collation-settings-in-phpmyadmin

https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation

You can also ask this to your host provider and they will change it for you .

1 user says Thank You to Pankaj Sharma for this useful post

1. pressmar

[pressmar Friend pressmarJoin date: March 2008Posts: 119Downloads:14Uploads:51 Thanks: 25 Thanked: 4 times in 1 posts]

#948841

Okay it worked, but was really a shity work to manually change each variable in every table. But now it works even on the live hoster. Thanks for you help.

[Author]

Posts