OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
utf8mb4_unicode_ci Collation - issues (0 viewing) 
SEF Translate component support
Go to bottom Favoured: 0
TOPIC: utf8mb4_unicode_ci Collation - issues
#44659
joomleb (User)
Expert Boarder
Posts: 131
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 3 Days, 15 Hours 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.
#44662
admin (Admin)
Admin
Posts: 7128
graph
User Online Now Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 2 Days, 17 Hours ago Karma: 84  
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.
#44664
joomleb (User)
Expert Boarder
Posts: 131
graphgraph
User Offline Click here to see the profile of this user
Re:utf8mb4_unicode_ci Collation - issues 2 Days, 15 Hours 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
What are you looking for?
Anti-spam question: How many head has a typical person?