SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Length of data

  1. #1
    SitePoint Guru augathra's Avatar
    Join Date
    Jul 2004
    Location
    united states
    Posts
    826
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Length of data

    Hi, if I make a column INT(255), and I know 100% sure that no data will be no more than 5 numbers long, am I *using* any extra CPU resources, or is it exactly the same?

    Thank you

  2. #2
    SitePoint Guru
    Join Date
    Jan 2004
    Location
    Uppsala, sverige
    Posts
    695
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)
    An int column will always use 4 bytes for storage. The 255 only affects the display format.


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
  •