Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is the basic diffrence betn a col declared in char(1)
and in varchar(1)

Question Posted / lopa

Answers were Sorted based on User's Feedback



what is the basic diffrence betn a col declared in char(1) and in varchar(1)..

Answer / nilam gandhi

char(1) is a fixed length character data,size character long.
Maximum size 2000 bytes.
Default size is 1 byte.
Varchar(1) is a variable length character string.
And the maximum size of the varchar(1) data type is 4000 bytes.

Is This Answer Correct ?    2 Yes 1 No

what is the basic diffrence betn a col declared in char(1) and in varchar(1)..

Answer / penchal das

Char is static in size where as Varchar is dynamic in size.

if we use char(15) and we have used only 10 charectes then remaining memory space will be wasted.

In case of Varchar(15) if use 10 chars remaining memory space will be freed.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

How many types of triggers are there?

0 Answers  

What is replication with database mirroring? : sql server database administration

0 Answers  

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

What are built in functions?

0 Answers  

What is normalization process?

0 Answers  

Relational calculus is what type of language?

0 Answers   HCL,

What do you mean by normalisation?

0 Answers  

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

Explain the purpose of indexes?

0 Answers  

What do you mean by data manipulation language?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories