Error when posting a comment with a smiley face

Comments

• denn New

  August 2020 edited August 2020

  MariaDB [forum]> SHOW CREATE DATABASE `forum`;                                                                                             
  +-----------+--------------------------------------------------------------------------------------------------+                                   
  | Database  | Create Database                                                                                  |                                   
  +-----------+--------------------------------------------------------------------------------------------------+                                   
  | forum | CREATE DATABASE `forum` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ |                                   
  +-----------+--------------------------------------------------------------------------------------------------+                                   
  
  MariaDB [forum]> show variables WHERE Variable_name LIKE 'character\_set\_%'  OR Variable_name LIKE 'collation%';                              
  +--------------------------+--------------------+                                                                                                  
  | Variable_name            | Value              |                                                                                                  
  +--------------------------+--------------------+                                                                                                  
  | character_set_client     | utf8               |                                                                                                  
  | character_set_connection | utf8               |                                                                                                  
  | character_set_database   | utf8mb4            |                                                                                                  
  | character_set_filesystem | binary             |                                                                                                  
  | character_set_results    | utf8               |                                                                                                  
  | character_set_server     | utf8               |                                                                                                  
  | character_set_system     | utf8               |                                                                                                  
  | collation_connection     | utf8_general_ci    |                                                                                                  
  | collation_database       | utf8mb4_unicode_ci |                                                                                                  
  | collation_server         | utf8_general_ci    |                                                                                                  
  +--------------------------+--------------------+                                                                                                        
  
                                                                            
  the forum was moved to a new domain. Export / import of the database was done via phpmyadmin. All settings were set by default.
  

  
  

  0
• denn New

  August 2020 edited August 2020

  I found a solution. Maybe someone will need it.

  [mysqld]

  collation-server=utf8mb4_unicode_ci

  init-connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'

  character-set-server=utf8mb4

  [client]

  default-character-set=utf8mb4

  [mysql]

  default-character-set=utf8mb4

  2