时间戳

首页 > 解决方案 > steps to convert single databse to utf8mb4 in mysql

mysql - steps to convert single databse to utf8mb4 in mysql

问题描述

i want to change the character set of a table in mysql database to utf8mb4 without changing in config file .i dont want entire database to use utf8mb4 .

i already changed the database,table and procedures character set and collation to utf8mb4 

alter database DBNAME CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
alter table tblname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

i want to store emojis in mysql databse without changing the entire database to utf8mb4 .please help me

标签： mysqldatabase-administrationutf8mb4character-set

解决方案

推荐阅读