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

What is SQL Server?

1271


How to make remote connection in database?

1049


What is data set in report?

147


What are the different types of locks in the database?

972


How to include date and time values in sql statements?

1142


Do you know the capabilities of cursors?

1217


Does windows server 2016 come with sql server?

986


What is the datatype of rowid?

963


What is model database in sql server?

1103


What is a full text index?

965


Can you leave a union at any time?

1106


What are the requirements on sql server network connections?

1041


Can we write ddl in trigger?

969


Are all views updatable ?

1201


Can the query output be sorted by multiple columns in ms sql server?

1028