Incorrect string value: '\xF0\x9F\x8E\xB6\xF0\x9F...' MySQL Debug

preview_player
Показать описание

Failed:
CREATE DATABASE inventory CHARACTER SET utf8;

CREATE TABLE inventory.`sku` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`supplier_id` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=2379669 DEFAULT CHARSET=UTF8 ROW_FORMAT=DYNAMIC;

Success:
create database inventory2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

CREATE TABLE inventory2.`sku` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`supplier_id` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB AUTO_INCREMENT=2379669 DEFAULT CHARSET=UTF8MB4 COLLATE UTF8MB4_UNICODE_CI ROW_FORMAT=DYNAMIC;

Рекомендации по теме
visit shbcf.ru