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

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

What is dknf in normalization form?

0 Answers  

What is xdr?

0 Answers  

Find nth lowest salary or get nth lowest salary?

0 Answers  

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

What are clustered and non-clustered index?

0 Answers  

How to optimize stored procedure optimization?

0 Answers  

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

Magic Tables ?

2 Answers   Thomson Reuters,

event classes in sql server

2 Answers   Accenture, AFE,

What is the difference between for trigger and after trigger?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories