![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
superman5220
这个作者很懒,什么都没留下…
展开
-
Mysql的大字段问题
【问题描述】Mysql报错: ERROR 1118 (42000) at line 703: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs【导原创 2017-04-12 20:03:52 · 1593 阅读 · 0 评论 -
Mysql utf8 格式 升级为 utf8mb4
1.utf8mb4的最低mysql版本支持版本为5.5.3+,若不是,请升级到较新版本。 2.修改database、table和column字符集。参考以下语句:ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE =utf8mb4_unicode_ci;ALTER TABLE table_name CONVERT TO CHA原创 2017-04-12 20:13:37 · 3550 阅读 · 0 评论 -
解决 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
1.线上BUG报错:org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select count(*) from player where name=?]; SQL state [HY000]; error code [12原创 2017-07-19 09:56:18 · 28207 阅读 · 1 评论