Minimal setup for MariaDB to handle Emojis

Question

I followed https://stackoverflow.com/a/35189650/4534 but still I get Error 1366: Incorrect string value, when posting an emoji into "name":

INSERT INTO `users` (`name`) VALUES ('Foo bar ');

SQL setup is:

SET NAMES utf8mb4;
CREATE DATABASE rest_api_example;
USE rest_api_example;
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    age INT NOT NULL
);

I use the mariadb image to test the above sql via https://github.com/kaihendry/GoApiTutorial/blob/master/docker-compose.yml

Please provide `SHOW CREATE TABLE users;` in the failing case. — Rick James, May 09 '19 at 03:58

hendry · Accepted Answer · 2019-05-09T05:45:55.177

When I add command: ['--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci'] to the docker-compose.yml

Once I've done this, Emoji characters appear to work. However I've since discovered I can set charset/collation in the database creation, for example:

 CREATE DATABASE rest_api_example character set utf8mb4 collate utf8mb4_unicode_ci;

And that works better and I don't have to fiddle with mysqld settings.

Minimal setup for MariaDB to handle Emojis

1 Answers1