> 7. What does zerofill do to a integer field? A database is
> meant to store data, not to format it while storing.
> Actually I find this to be a nice feature...if necessary.  
> For instance you are using Auto_Increment INT field and you
> are using it as your order number.  Maybe you want all of
> your order numbers to be a specific length.

I actually found it usefull with barcodes which in the US are only 12 digits
but in Europe are exactly the same format but 13 digits long.  Adding a zero
to the beginning of a US code makes it a European compatible code.

--
Jay
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to