469,615 Members | 1,615 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,615 developers. It's quick & easy.

ZEROFILL

Hi,
What is the practical use of ZEROFILL in your case?

regards,
Khaz
Jul 23 '05 #1
3 18996
Khazret Sapenov wrote:
What is the practical use of ZEROFILL in your case?


I have not had a need to use that feature in my projects, but sometimes
people have an integer field that must have uniform length, so they
prefer to have the leading portion fill with zeroes.

For instance:
http://groups-beta.google.com/group/...90b6cac8da980/

Regards,
Bill K.
Jul 23 '05 #2
Bill,
I have read the link, however it's unclear what is the "specific reason".
Anyway thank you for your time.

regards,
Khazret Sapenov

"Bill Karwin" <bi**@karwin.com> wrote in message
news:cu*********@enews3.newsguy.com...
Khazret Sapenov wrote:
What is the practical use of ZEROFILL in your case?
I have not had a need to use that feature in my projects, but sometimes
people have an integer field that must have uniform length, so they
prefer to have the leading portion fill with zeroes.

For instance:

http://groups-beta.google.com/group/...90b6cac8da980/
Regards,
Bill K.

Jul 23 '05 #3
Khazret Sapenov wrote:
I have read the link, however it's unclear what is the "specific reason".


The link just demonstrates that there exists a person who has that
requirement to pad integers with zeroes, and the ZEROFILL attribute was
the solution.

I think it's just a convenience. A programmer could format the value
that way after fetching it from the database, but apparently it's a
common enough task that MySQL can do it for you if you need it.

As for why someone would want this, it can help in some documents to
make integers of uniform length, so that they align with each other
regardless of being right- or left-justified.

Regards,
Bill K.
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Westcoast Sheri | last post: by
2 posts views Thread by NotVeryBright | last post: by
reply views Thread by someone | last post: by
8 posts views Thread by Richard Maher | last post: by
2 posts views Thread by WebSnozz | last post: by
1 post views Thread by sonia.sardana | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.