Re: field's length???

2005-02-16 Thread Robert Munn
The 4 means that the int datatype uses four bytes of memory. > I know that int type can hold from -2,147,483,648 to 2,147,483,647, > but when we design the table, we put the length to be 4. So even if we > set the length to 4, can it hold more than 4 digits? I believe it can, > but I forgot the

RE: field's length???

2005-02-16 Thread Dawson, Michael
umeric" or "decimal". Character-based fields are specified by the number of characters (bytes) as you correctly state. -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 16, 2005 9:30 AM To: CF-Talk Subject: field's length??? Hi, I kn

field's length???

2005-02-16 Thread Johnny Le
Hi, I know that int type can hold from -2,147,483,648 to 2,147,483,647, but when we design the table, we put the length to be 4. So even if we set the length to 4, can it hold more than 4 digits? I believe it can, but I forgot the explanation for it. Something about 8^4, but that is the size of