Hello,
if i use the national number format, the integer will be displayed with tousend seperators. That's a nice feature. But if i have a ZEROFILL integer, this will be ignored to display.
CREATE TABLE test
(
test
SMALLINT(4) UNSIGNED ZEROFILL NULL DEFAULT NULL
)
ENGINE=MyISAM
;
INSERT INTO test
(test
) values (0), (999), (1000), (1999);
Now the table for german (tousend seperator is . and decimal point is ,) shows:
test
0000 0999 1.000 1.999
that's wrong! I would say if the ZEROFILL is defined, no national formats are used (first two lines)!
Martin