Subject mySQL ZEROFILL option its need in FireBird?
Author Johannes Pretorius
Good day
=-\\-=\-=\-=\

got this part out of the mySQL docs

//============================================
When used in conjunction with the optional extension attribute ZEROFILL,
the default padding of spaces is replaced with zeros. For example, for a
column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004.
Note that if you store larger values than the display width in an integer
column, you may experience problems when MySQL generates temporary tables
for some complicated joins, as in these cases MySQL trusts that the data
did fit into the original column width.

//============================================

Was wondering if there is a need like this is FireBird ?. I can think for
values that is stored
for barcodes it can be handy, but the rest it seems has only display meaning.

Is there any other need or is there a need at all in the FireBird userbase
for this ??

Just wondering :)

Thanks in Advance for any comments

Johannes Pretorius




----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.672 / Virus Database: 434 - Release Date: 28/04/2004


[Non-text portions of this message have been removed]