unicode_ci ，以便能保存一些emoji火星文 , 结果有一个sql语句执行时，报错如下： Illegalmixofcollations (utf8_unicode_ci,IMPLICIT) and (utf8...END character_set_client: utf8mb4 collation_connection: utf8mb4_unicode_ci Database Collation: utf8
DEFAULT CHARSET=utf8 COMMENT='测试表'; 以上就是Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8
table_b b on a.field_a = b.field_b error： Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8...table_a a left join table_b b on CONVERT(a.field_a USING utf8) COLLATE utf8_unicode_ci = b.field_b 注：utf8
NOT NULL AUTO_INCREMENT COMMENT '管理员id', `login_user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8..._general_ci NOT NULL COMMENT '管理员登陆名称', `login_password` varchar(50) CHARACTER SET utf8 COLLATE utf8...) NOT NULL AUTO_INCREMENT COMMENT '博客表主键id', `blog_title` varchar(200) CHARACTER SET utf8 COLLATE utf8...NOT NULL COMMENT '博客封面图', `blog_content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT..._general_ci NOT NULL COMMENT '博客分类(冗余字段)', `blog_tags` varchar(200) CHARACTER SET utf8 COLLATE utf8
TABLE `user_db` ( `id` bigint(20) NOT NULL, `username` varchar(255) CHARACTER SET utf8 COLLATE utf8...DEFAULT NULL, `fullname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL..., `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY...NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `..._general_ci NOT NULL, `role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
DEFAULT NULL COMMENT '属性录入方式：0->手工录入；1->从列表中选取', `input_list` varchar(255) CHARACTER SET utf8 COLLATE utf8...PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 74 CHARACTER SET = utf8 COLLATE = utf8...product_attribute_id` bigint(20) NULL DEFAULT NULL, `value` varchar(64) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL COMMENT '图标', `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_..._general_ci NULL, `pics` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
branch_table` ( `branch_id` bigint(20) NOT NULL, `xid` varchar(128) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL, `resource_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci...NULL DEFAULT NULL, `branch_type` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT...NULL, `status` tinyint(4) NULL DEFAULT NULL, `client_id` varchar(64) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL, `table_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci
## mysql自带test数据库表的默认属性：Collation latin1_swedish_ci 更新为utf8_general_ci，解决MYSQL数据库乱码 USE test; CREATE...SHOW CHARACTER SET; -- 查看utf8字符集信息(从命令中查询) SHOW CHARACTER SET LIKE 'utf8'; # utf8 UTF-8 Unicode utf8...查看所有排列字符集(从命令中查询) SHOW COLLATION; -- 查看utf8的所有排列字符集(从命令中查询) SHOW COLLATION WHERE CHARSET = 'utf8'; # utf8..._general_ci'; ##修改表的编码(修改) ALTER TABLE sys_log CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; ##查看列属性...TABLE sys_log MODIFY PARAMS VARCHAR(500) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; ALTER TABLE
EXISTS `background`; CREATE TABLE `background` ( `back_id` varchar(50) CHARACTER SET utf8 COLLATE utf8...50) NOT NULL AUTO_INCREMENT COMMENT '预定信息id', `guest_id_card` varchar(50) CHARACTER SET utf8 COLLATE utf8...NULL DEFAULT '0000-00-00 00:00:00' COMMENT '预计退房时间', `rank` varchar(10) CHARACTER SET utf8 COLLATE utf8...0 COMMENT '预定处理状态，0代表未处理，1代表已处理,11代表已入住(失效)', `result_room` varchar(20) CHARACTER SET utf8 COLLATE utf8..._general_ci NOT NULL COMMENT '客户的身份证号', `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci
`userId` int(11) DEFAULT NULL COMMENT '关联拥有人', `bookname` varchar(255) CHARACTER SET utf8 COLLATE utf8..._general_ci DEFAULT NULL COMMENT '书名', `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci..._general_ci DEFAULT NULL COMMENT '图书封面', `verifystatus` varchar(255) CHARACTER SET utf8 COLLATE utf8..._general_ci DEFAULT NULL COMMENT '审核状态，审核通过展示', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8...NOT NULL COMMENT '名字', `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT
uroot -p123456 2 初始化CDH在MySQL的数据库 create database scm default character set utf8 default collate utf8...'scm'@'%' identified by '123456'; create database amon default character set utf8 default collate utf8...'amon'@'%' identified by '123456'; create database rman default character set utf8 default collate utf8...'rman'@'%' identified by '123456'; create database hue default character set utf8 default collate utf8...123456'; 2 初始化Hive服务的数据库 create database metastore default character set utf8 default collate utf8
_general_ci NULL DEFAULT NULL, `resource_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci...NULL DEFAULT NULL, `lock_key` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT...` tinyint(4) NULL DEFAULT NULL, `client_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci...NULL DEFAULT NULL, `application_data` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL...utf8_general_ci NULL DEFAULT NULL, `table_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci
DEFAULT NULL, `varchar(2)` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL...)` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `varchar255)` varchar...(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `char(0)` char(0) CHARACTER SET...utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `char(1)` char(1) CHARACTER SET utf8 COLLATE utf8_...SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `placeholder` varchar(200) CHARACTER SET utf8
t_book` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8...PRIMARY KEY (`cid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8..._general_ci NULL DEFAULT NULL, `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL...DEFAULT NULL, `age` int(11) NULL DEFAULT NULL, `sex` varchar(20) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL, `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL
`uuid` AS CHAR CHARACTER SET utf8 ) COLLATE utf8_general_ci LIKE '%/product%' OR CAST( `shop`....`contentTitle` AS CHAR CHARACTER SET utf8 ) COLLATE utf8_general_ci LIKE '%/product%' OR CAST( `shop`...`introduction` AS CHAR CHARACTER SET utf8 ) COLLATE utf8_general_ci LIKE '%/product%' OR CAST( `shop`...`icon` AS CHAR CHARACTER SET utf8 ) COLLATE utf8_general_ci LIKE '%/product%' OR CAST( `shop`....`url` AS CHAR CHARACTER SET utf8 ) COLLATE utf8_general_ci LIKE '%/product%'; 发布者：全栈程序员栈长，转载请注明出处：https
branch_table` ( `branch_id` bigint(20) NOT NULL, `xid` varchar(128) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL, `resource_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci...NULL DEFAULT NULL, `branch_type` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT...NULL, `status` tinyint(4) NULL DEFAULT NULL, `client_id` varchar(64) CHARACTER SET utf8 COLLATE utf8...USING BTREE, INDEX `idx_xid`(`xid`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8
`branch_table` ( `branch_id` bigint(20) NOT NULL, `xid` varchar(128) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL, `resource_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci...NULL DEFAULT NULL, `branch_type` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT...NULL, `status` tinyint(4) NULL DEFAULT NULL, `client_id` varchar(64) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL, `transaction_service_group` varchar(32) CHARACTER SET utf8 COLLATE utf8
创建数据库时,设置数据库的编码方式 -- CHARACTER SET:指定数据库采用的字符集,utf8不能写成utf-8 -- COLLATE:指定数据库字符集的排序规则,utf8的默认排序规则为utf8... character set查看） drop database if EXISTS dbtest; create database dbtest CHARACTER SET utf8 COLLATE utf8...database dbtest CHARACTER SET GBK COLLATE gbk_chinese_ci; alter database dbtest CHARACTER SET utf8 COLLATE utf8...CHARACTER SET GBK COLLATE gbk_chinese_ci, email varchar(60), PRIMARY key(id) )CHARACTER SET utf8 COLLATE utf8..._general_ci; -- 修改表编码 alter table tbtest character set utf8 COLLATE utf8_general_ci; -- 修改字段编码 ALTER
Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8..._general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +...>set character_set_server =utf8; mysql>set character_set_system =utf8; mysql>SET collation_server = utf8..._general_ci; mysql>SET collation_database = utf8_general_ci; 修改数据库默认字符集： mysql>ALTER DATABASE `zabbix..._general_ci | | collation_database | utf8_general_ci | | collation_server | utf8_general_ci | +
`user_id` int(16) NOT NULL AUTO_INCREMENT, `user_name` varchar(128) CHARACTER SET utf8 COLLATE utf8...tinyint(4) NULL DEFAULT 2 COMMENT '用户性别：0：女 1：男 2：未知', `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8..._general_ci NULL DEFAULT NULL COMMENT '手机号', `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci...NULL DEFAULT NULL COMMENT '邮箱', `address` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci...int(16) NOT NULL AUTO_INCREMENT COMMENT '主键', `goods_name` varchar(64) CHARACTER SET utf8 COLLATE utf8
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
即时通信 IM
实时音视频
