OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
utf8mb4_unicode_ci Collation - issues (0 viewing) 

Joomla Translate component support

Go to bottom Favoured: 0

Utf8mb4_unicode_ci Collation - issues

joomleb (User)
Gold Boarder
Posts: 202
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 4 Months ago
Karma: 0  
Hi Andrew,
Maybe it can cause some issues, I noted I have:
Server Connection Collation set as utf8mb4_unicode_ci
Database > Tables > Columns are all set as utf8mb4_unicode_ci
I run Admin Tools > Change Database Collation > Custom: utf8mb4_unicode_ci

Why I have back Joomla > System Information > Database Connection Collation: utf8mb4_general_ci ?
photos.app.goo.gl/PgMC9Qxv83MEaM6X6

It should be utf8mb4_unicode_ci, Am I right ?
Please, Am I missing anything ?
Please, Do you have any suggestions on How can I change it ?
Logged Logged
Last Edit: 2020/11/22 20:08 By joomleb.
The administrator has disabled public write access.
admin (Admin)
Admin
Posts: 8243
graph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 4 Months ago
Karma: 101  
Hi

For MySQL the Joomla show Database Connection Collation, with help SQL request:

SHOW VARIABLES LIKE "collation_connection"

Regards
OrdaSoft team
Logged Logged
The administrator has disabled public write access.
joomleb (User)
Gold Boarder
Posts: 202
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Years, 4 Months ago
Karma: 0  
HI Andrew,
really many thanks, I tested and investigated it.
I reported it on Joomla GitHub, because I suspect it can be a Joomla BUG (I have back the same on new Joomla 4 beta 5 installation): github.com/joomla/joomla-cms/issues/31468
Logged Logged
The administrator has disabled public write access.
Go to top
»