摘要： Description In mysql-connector-java-5.1.27, the charset utf8mb4 is supported. But the steps and result bellow looks buggy.1、 set character_set_server=gbk in my.cnf2、 start mysql3、 execute set global character_set_server=utfmb4;4、 insert a data with utf8mb4 charactersResult: error data inserted.Analy 阅读全文

摘要： mysql> select date_format('2013-11-19','Y-m-d') > timediff('2013-11-19', '2013-11-20'); ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '>'乍一看挺莫名其妙的，查了下手册，发现有这么一段：The language use 阅读全文