#22309 Database Collation - Admin tools

Posted in ‘Pre-sales and Account Questions’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Hi Nick
Please do not remove this features
I just installed Jevents and it used the Swedish Collation instead of utf8_general_ci.

It helped me to fix.


This feature is deprecated and will be removed

This feature was only really necessary for Joomla! 2.5 and earlier versions. It will be removed in a future version of Admin Tools, when we discontinue Joomla! 2.5 support. Please consult the News section of our site for information regarding Joomla! 2.5 support.

Akeeba Staff
This feature has already been removed in Admin Tools 3.5.0. There is a much better way to work around that:
  • Take a backup of your site
  • Create a new database with default collation set to utf8_general_ci. You may want to ask your host how to do this.
  • Restore the backup into the NEW database.
  • Remove the OLD database.

From this point onwards all tables created in the database will inherit the default utf8_general_ci collation unless specifically stated otherwise. In the latter case please contact the developer of the software you are using and have them correct the SQL installation files of their extensions.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!

Summer vacations: Our support will be closed for replies and new tickets from August 6th to August 21st, 2022 due to summer vacations.