Re: DBMS
char is fixed length, right padded with spaces
varchar (SQL-92) is fixed length, right padded with null
varchar2 is variable length
The main difference between varchar and varchar2 is that varchar is an ANSI standard that takes up a fair amount of space. I believe varchar2 is oracle only and makes more efficient use of space.
J. Shivers
Subject
Written By
Posted
September 03, 2004 04:50AM
Re: DBMS
September 03, 2004 09:03AM
September 03, 2004 01:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.