教育叙事范文,3d肉蒲团 高清,宅急送快递费用查询
今天帮同事处理一个sql(简化过后的)执行报错:
error 1267 (hy000): illegal mix of collations (utf8_general_ci,coercible) and (latin1_swedish_ci,numeric) for operation '>'
the date_format() returns a string with a character set and collation given by character_set_connection and collation_connection so that it can return month and weekday names containing non-ascii characters.
mysql> set names gb2312;
mysql> select charset(date_format('2013-11-19','y-m-d')), charset(timediff('2013-11-19', '2013-11-20'));
+--------------------------------------------+-----------------------------------------------+
| charset(date_format('2013-11-19','y-m-d')) | charset(timediff('2013-11-19', '2013-11-20')) |
+--------------------------------------------+-----------------------------------------------+
| gb2312 | binary |
+--------------------------------------------+-----------------------------------------------+
p.s,mysql的版本:5.5.20-55-log percona server (gpl), release rel24.1, revision 217
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
网友评论