Resolved collation_database

[dyrer]

+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8mb4_unicode_ci |
+--------------------------+--------------------+

Hi
How can also switch collation_database to utf8mb4_unicode_ci

 

[IgorG]

Note, that utf8mb4 Character Set (4-Byte UTF-8 Unicode Encoding) support is available starting from the MySQL 5.5.3 version.
'utf8mb4_unicode_520_ci' collation present by default there.

 

[dyrer]

I am running Debian 9 and mariadb 10.1 but there still problem
Image 2018-05-28 at 6.42.05 PM.png


No support for MySQL Database 4-byte UTF-8 support

 

[Bitpalast]

That's strange. I just imported a database that used utf8mb4 into a Maria DB 10.1. Maybe the software manufacturer of the application can help to identify what's wrong? I doubt that this is a database issue.

 

[dyrer]

systemctl list-unit-files | grep enabled | grep -iE '(sql|db)'

mariadb.service                          enabled
mysql.service                            enabled
mysqld.service                           enabled

Is this correct running three services?

 

[dyrer]

I had to add into /etc/mysql/conf.d/my.cnf

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

my complete my.cnf is

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
init-connect='SET NAMES utf8mb4'
collation_server=utf8mb4_unicode_ci
character_set_server=utf8mb4
skip-character-set-client-handshake

innodb_large_prefix=true
innodb_file_format=barracuda
innodb_file_per_table=true

 

[Bitpalast]

Is this correct running three services?

Yes, it is correct response. It is not exactly three services, but one service and two aliases.

 

[Bitpalast]

I had to add into /etc/mysql/conf.d/my.cnf

And afterwards your issue is solved?

 

[dyrer]

Yes solved.
No needed to add utfmb8, is my preference
This solves problem for Drupal, and Backdrop CMS (is a drupal fork)