Support

Pre-sales

#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.

Latest post by nicholas on Friday, 20 March 2015 04:54 CDT

Friday, 20 March 2015 04:14 CDT

giora
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.

Thanks
Giora

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.

Friday, 20 March 2015 04:54 CDT

nicholas
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: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

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!