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

Thread: varchar2 dataype

  1. 11-06-2001, 11:34 AM #1
    UNIX DBA
    UNIX DBA is offline Member
    Join Date
    Sep 2001
    Posts
    112
    If I have

    varchar2(2000) with a 10 character word in it and

    varchar2(10) with the same word in it. Which column is using more space? If any
    Reply With Quote Reply With Quote
  2. 11-06-2001, 11:41 AM #2
    jgmagnus
    jgmagnus is offline Senior Member
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Cool

    should be same assuming that each column only has that one field in it.

    - magnus
    Reply With Quote Reply With Quote
  3. 11-06-2001, 11:47 AM #3
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Both will require 10 bytes.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width