Mysql
sunweijm
这个作者很懒,什么都没留下…
展开
-
mysql存储emoji表情(utf8mb4编码)报错
tigase保存聊天记录时出现如下错误:java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8D\xE5\x93...' for column '_body' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at原创 2017-08-04 15:07:12 · 1864 阅读 · 1 评论 -
mysql ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) ....
迁移服务器时,重建mysql数据库,将数据库的编码格式改为了utf8mb4(见该篇),以便能够存储emoji表情.在遇到一个执行procedure报错 : call TigAddUserPlainPw(‘db-properties’, NULL);ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_general_ci,COERCIBLE)原创 2017-08-21 17:22:39 · 5046 阅读 · 0 评论 -
ERROR 1067 (42000): Invalid default value for .....
在建表时遇到这样的报错: ERROR 1067 (42000): Invalid default value for ‘last_login’解决方法: 两步: S1.mysql> show variables like 'sql_mode' ;+---------------+---------------------------------------------------------原创 2017-08-30 10:19:46 · 3836 阅读 · 0 评论 -
centos7 rpm安装或者升级mysql5.7
1.从官网https://dev.mysql.com/downloads/file/?id=470281 找到下载rpm链接:https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm 2.[sunwei@localhost mysqlDownload]$ wget https://repo.mysql.com//mysq原创 2017-09-11 15:22:28 · 1062 阅读 · 0 评论