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

Thread: varchar & varchar2

  1. #1
    Join Date
    Apr 2001
    Posts
    112

    I found in Oracle datatypes documentation the following:
    difference between varchar & varchar2 is
    "a varchar2 is like varchar but 2 byte length followed by buffer"
    I could absolutely understand nothing from it. Could you please put more light on it.

    Thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Varchar2 is an improved verion of Varchar. I think in Varchar there is a 2 byte space allocated that stores the length of actual data stored in that field.

    Why worry about it when there are no practical implications !
    Sridhar R Patnam

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