Professional Web Applications Themes

Numeric Data Type limits - MySQL

Hey I am trying to build a database and when I create certain fields with the Int data type, the minimum number I can enter is a 6. Why does it not let me enter a smaller number? Also the same thing happens when I try to specify the length of an Int data type, but instead of the number being a 6, its an 11. I thought I could specify how large I wanted to the field to be... Any help is greatly appreciated. Todd...

  1. #1

    Default Numeric Data Type limits

    Hey

    I am trying to build a database and when I create certain fields with the
    Int data type, the minimum number I can enter is a 6. Why does it not let
    me enter a smaller number?

    Also the same thing happens when I try to specify the length of an Int data
    type, but instead of the number being a 6, its an 11.

    I thought I could specify how large I wanted to the field to be...

    Any help is greatly appreciated.
    Todd


    Todd Guest

  2. #2

    Default Re: Numeric Data Type limits

    Todd Huttenstine wrote: 

    the Int data type, the minimum number I can enter is a 6.
    Int data type, but instead of the number being a 6, its an 11

    Isn't this a contradiction?


    Paul Guest

  3. #3

    Default Re: Numeric Data Type limits

    On Wed, 28 Mar 2007 16:47:49 -0400, Todd Huttenstine wrote:
     

    An INT is an INT. A BIGINT is a BIGINT. A TINYINT is a TINYTINT. You
    don't get to specify how big they are. Do you perhaps want DECIMAL?

    --
    "The bullets are just his way of saying 'Keep it down, I've got a
    hangover.'"
    Kiki to Dr. Schlock, as seen in http://pics.sluggy.com/comics/000108a.gif
    Peter Guest

Similar Threads

  1. #39056 [NEW]: Interbase NUMERIC data type error
    By ddi at elecom dot ru in forum PHP Bugs
    Replies: 1
    Last Post: October 6th, 06:50 AM
  2. CFFile File Type Limits
    By cluksha in forum Macromedia ColdFusion
    Replies: 3
    Last Post: September 17th, 12:56 PM
  3. Sending Numeric Type Variable From DataGrid toColdFusion
    By Anto111 in forum Coldfusion Flash Integration
    Replies: 3
    Last Post: March 25th, 05:43 PM
  4. Numeric type
    By phil campaigne in forum PostgreSQL / PGSQL
    Replies: 1
    Last Post: January 27th, 11:30 AM
  5. Replies: 1
    Last Post: October 13th, 01:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139