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

What are the types of sql server?

0 Answers  

How to get the definition of a stored procedure back?

0 Answers  

What does top operator do?

0 Answers  

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

how to generate XML out of QUERY?

1 Answers   McAfee,

What is 1nf normalization form?

0 Answers  

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

How create table structure only from tableA to TableB if TableA have some data?

4 Answers  

Relational calculus is what type of language?

0 Answers   HCL,

What is a cursor, index in sql?

0 Answers  

How to run sql server 2005 books online on your local system?

0 Answers  

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

For more SQL Server Interview Questions Click Here
Categories