Windows Navicate for MySQL 0 fill does not display

In the MySQL database we often need a field to use the zero padding Zerofill, before encountering a big pit, in the data table SQL statement clearly defined unsigned zerofill; but it has not been shown that the SQL statement you wrote is not correct.

In fact, the reason:

Linux vs. Navicate: (later not sure you can go to Linux or print in PHP)

CREATE TABLE ' Test ' (
' id ' int (ten) unsigned not NULL auto_increment,
' Num ' int (3) unsigned zerofill not NULL,
' Flo ' float (3,1) DEFAULT NULL,
KEY ' id ' (' id ') USING BTREE
) Engine=innodb auto_increment=3 DEFAULT Charset=utf8 row_format=compact;

Windows Navicate for MySQL 0 fill does not display