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...

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is snapshot parameter in ssrs?

150


Explain go command in sql server?

1030


How does the report manager work in SSRS?

148


How do I install sql server?

884


How to send a ssrs report from ssis?

176


What is a trigger what are the advantages of trigger?

995


What are the basic features of a trigger in ms sql server?

1186


How do I create a stored procedure in sql server?

1032


Explain throw statement in sql server 2008?

989


Can we insert data into a view?

1131


What is database architecture? : SQL Server Architecture

1039


How to search for a string in all stored procedure in sql server?

996


What are various limitations of the views?

1049


What are the system database in sql server 2008?

1028


what is the system function to get current user's user id? : Sql server database administration

995