FIX for Error Code: 1366. Incorrect string value: '\xF0\x9F\x98\x98' for column

mysql or maria db charset.sql

Info >  https://stackoverflow.com/questions/8906813/how-to-change-the-default-charset-of-a-mysql-table

SELECT * FROM `gw-local-2`.posts;
SET character_set_system = utf8mb4;

UPDATE `gw-local-2`.posts SET content = '😘 asd' where id='9552a88e-cd97-4130-8daa-d0bb48977ebc';
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

/* The actual fix */
ALTER TABLE `gw-local-2`.posts
  CHANGE COLUMN content content varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;