Comments

indigoxela's picture

Wed, Oct 05, 2022 - 7:30am by indigoxela

Hi robertgarrigos,

I'm having problems to get utf8mb4 support on a mysql 8 installation.

I'm assuming you already checked the variables in either a mysql shell or in phpmyadmin:

[mysqld]
innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

...and they fit.

Is it a website you migrated from another server, or is it a site you upgraded from Drupal?

Is it the conversion to utf8mb4, that fails or is it the charset for a new install?

robertgarrigos's picture

Mon, Jun 05, 2023 - 2:00am by robertgarrigos

I'm still fighting with this. Mysql 8 doesn't start with those variables.... any ideas?

Even more, I believe my mysql8 is already utf8mb4 capable:

mysql> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name            | Value              |
+--------------------------+--------------------+
| character_set_client     | utf8mb4            |
| character_set_connection | utf8mb4            |
| character_set_database   | utf8mb4            |
| character_set_filesystem | binary             |
| character_set_results    | utf8mb4            |
| character_set_server     | utf8mb4            |
| character_set_system     | utf8mb3            |
| collation_connection     | utf8mb4_0900_ai_ci |
| collation_database       | utf8mb4_0900_ai_ci |
| collation_server         | utf8mb4_0900_ai_ci |
+--------------------------+--------------------+
10 rows in set (0.00 sec)

However, backdrop status keeps saying taht MySQL Database 4-byte UTF-8 support is not enabled

robertgarrigos's picture

Mon, Jun 05, 2023 - 2:06am by robertgarrigos

Already fixed. Mysql8 doesn't need any setting on my.cnf. Once '$database_charset = 'utf8mb4';' is in settings.php, everything works fine. I was just looking at the wrong site.....