How come zerofill is not supported?

Will it be supported?

Any work around that would not cause issues or performance loss?

Hello,

Let me start with a reference to MySQL’s ZEROFILL:

http://dev.mysql.com/doc/refman/5.4/en/numeric-types.html

Additionally, I looked at:

http://bytes.com/topic/mysql/answers/141614-zerofill

Unfortunately, we don’t support it and it’s rather not planned.

Please write more about why you may need it? To format nicely the results of a query?

Best greetings,

Dominik

Hi !

What about using LPAD(field,width,‘0’) ?

From the MySQL Administrator’s Guide:

If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column.

Until Infobright supports the UNSIGNED integer data type, this would not be possible.