Support

Admin Tools

#25607 Collation UTF-8 Multibyte (utf8mb4) - Are there news?

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

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

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by on Saturday, 13 August 2016 17:20 CDT

Hotkeyharry
 Hi Dale, hi Nicholas,

are there news about switching collation to UTF-8 Multibyte (utf8mb4)?
I have some difficulties with switching.
On some sites its no problem to switch on other sites it doesn't (same Host) switch correct? It stays on utf8_general_ci ...

Yes plugin is activated, cache is cleared and I try it more than one time!?

Is there a workaround to check it out? Is it possible but is it a good idea to do it in the mySQL database within itself?

best regards
Harald

nicholas
Akeeba Staff
Manager
Since Joomla! 3.5.0, released two months ago, utf8mb4 is a core Joomla! feature. If your server supports it, updating Joomla! will switch your database to utf8mb4. You should not use the Admin Tools feature on Joomla! 3.5 and later (including 3.6).

Please keep in mind that for utf8mb4 to work you need to have a new enough version of MySQL, PHP, the MySQL connector libraries and the PHP-MySQL connecting code too. If one of your sites doesn't convert to utf8mb4 automatically it's just because the server doesn't support it. Nothing us or Joomla! can do about it (trust me, there is an entire 6-month-log saga in the Joomla! issue tracker about all the work half a dozen people did to make utf8mb4 work as smoothly as possible).

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!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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!