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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use stored procedures in sql server?

897


Write a code to select distinct records without using the DISTINCT keyword.

1052


What is Extended user-defined?

897


What is the ‘fillfactor’?

919


How do I find query history in sql server?

879


What is the process of normalization?

1058


How to view existing indexes on an given table using sp_help?

1055


What is abstracting periodical?

896


How to create a simple user defined function in ms sql server?

971


How do I uninstall sql server 2014?

881


What is the difference between char and varchar2 datatype in sql?

1009


Explain sql server service broker?

929


What is the usage of sign function?

1040


How you can change a cross join into an inner join?

912


How to generate create table script on an existing table in ms sql server?

1094