A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
How can we store the values in the DB
Joined: Nov 26, 2007
Jan 07, 2008 10:44:00
How can we store the value in the Data Base with the 0's in the before the number.
Ex:I have a number in the Db with value 36 , I want that value to be stored as 00036 in the DB.Can any one help me to do that.
Thanks in Advance,
Joined: Mar 22, 2005
Jan 07, 2008 10:52:00
Numbers don't have leading zeros, so the only option would be to store them as datatype varchar.
Ping & DNS
- my free Android networking tools app
S J Martin
Joined: Jul 31, 2007
Jan 07, 2008 13:48:00
Store them as the value that they are and worry about rendering where it matters. ;-)
Never attribute to malice that which is easily explained by incompetence.<br />SCJP (1.5)
I agree. Here's the link:
subject: How can we store the values in the DB
why we can't avoid hash collision in practice ?
Verifying the db file
(How do i do paging in JSP ????? HELP ME >URGENT
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014