varchar2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: varchar2

  1. #1
    Join Date
    Jun 2000
    Posts
    295
    Hi,

    Can anyone tell me what is disadvantage of
    using varchar2(4000) if varchar2(3) works?

    Thanks,


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    These questions would be more appropriate in the development forum. So I'm moving this from administration to the development forum...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2000
    Posts
    295
    No disadvantage so far?

    Then I will use varchar2(4000) all the time to avoid
    length limitation problems.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Let us take a practical example.
    You want to define a column, city.
    How many characters do you think this column will have?
    Say a maximum of 40.
    Then think of User Interface. Suppose if this column is displayed on the screen for user input, do you want to allocate 4000 characters or 40 characters?

    Think it over and determine the length.

Posting Permissions

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



Click Here to Expand Forum to Full Width