Basics - What is difference between varchar and varchar2

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 14 of 49

What is difference between varchar and varchar2

Total Answers and Comments: 21

Last Update: April 26, 2009 Asked by: Srinu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 3

« First

Last »

March 10, 2006 00:14:38

asheeshbarua

Member Since: March 2006 Contribution: 4

RE: What is difference between varchar and varchar2

varchar means fixed length char

varchar2 means variable length char

Is this answer useful? Yes | No

March 12, 2006 07:21:02

mitto

RE: What is difference between varchar and varchar2

can i get an example for the two.

Is this answer useful? Yes | No

March 12, 2006 13:52:41

niranjan rampure

RE: What is difference between varchar and varchar2

varchar stands for variable character length type

both are ideally same . varchar2 is supported by Oracle

varchar is supported by MSSQL server 2000

Is this answer useful? Yes | No

March 15, 2006 06:47:46

krishna

RE: What is difference between varchar and varchar2

Varchar and Varchar2 are both same except for varchar2 supports upto 2000 char

Is this answer useful? Yes | No

March 19, 2006 09:02:49

venkat_rolta

Member Since: March 2006 Contribution: 2

RE: What is difference between varchar and varchar2

both are same varchar is ANSI standardvarchar2 is Oracle

Is this answer useful? Yes | No

March 21, 2006 04:40:18

ramadass

RE: What is difference between varchar and varchar2

hi... in oracle name varchar(10)-in this declaration it allocate 10 spaces in memory.if suppose ur using 4 charecter the extra space wasted. name varcher2(10)-in this declaration the extra space used by other operations automatically.

Is this answer useful? Yes | No

April 10, 2006 07:57:13

Ankur

RE: What is difference between varchar and varchar2

when varchar means fixed leght character then what is the diff between char and varchar

Is this answer useful? Yes | No

April 20, 2006 06:12:32

shambhukjha

Member Since: April 2006 Contribution: 1

RE: What is difference between varchar and varchar2

Above said answer was wrong

. Actually both varchar and varchar2 means variable character string. varchar2 has been introduced in higher verson with higher limit. Means It can store more number of character as compared to Varchar

Is this answer useful? Yes | No

June 15, 2006 14:18:44

tjsivakumar

Member Since: June 2006 Contribution: 3

RE: What is difference between varchar and varchar2

Varchar and varchar2 are ideally the same. For backward compatibility both are accepted.

Is this answer useful? Yes | No

June 15, 2006 14:26:51

#10

tjsivakumar

Member Since: June 2006 Contribution: 3

RE: What is difference between varchar and varchar2