Re: checksum table incompatible change?

2009-03-24 Thread Cui Shijun
hi, Now I know it, sorry for the interruption :( The two mysql are compiled with different default character set parameters... It's easy to get confused for having NULL in utf8 != NULL in gbk, though. Thank you 2009/3/24 Cui Shijun : > hi, >  I tried this in mysql 5.1.22: > > mysql> crea

checksum table incompatible change?

2009-03-24 Thread Cui Shijun
hi, I tried this in mysql 5.1.22: mysql> create table t( value binary(16)) engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into t values( NULL ); Query OK, 1 row affected (0.00 sec) mysql> checksum table t; +---++ | Table | Checksum | +---++