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 a table be created inside a trigger?

0 Answers  

How do indexes help, types?

0 Answers  

how to connect sybase to sql server 2005?.

1 Answers   ABC,

What is ddl and dml commands?

0 Answers  

What is the significance of master, tempdb and model databases?

0 Answers  

What is transactional replication?

0 Answers  

What is relationship? What number of sorts of relationship are there?

0 Answers  

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

How to return the date part only from a sql server datetime datatype?

0 Answers  

What are the 7 disadvantages to a manual system?

0 Answers  

How will u find the query which is running in some other machine

4 Answers   CarrizalSoft Technologies, IBM,

Do you know what is fill factor and pad index?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories