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
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 |
+---++