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

why varchar takes 2 extra bytes?

Answer Posted / yuvaevergreen

to store the length of the data in the variable..
>>when char is used, spaces are padded to the length of the
vraiable.
>>In varchar, spaces are not padded, exact data alone is
stored along with the length.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between inner join and outer join?

1082


What is the syntax for case when statement?

1215


What are normalization, first normal form, second normal form and third normal form?

1101


List out some of the primary characteristics of teradata.

1060


How to load specific no.of records using bteq, or fastload,or multiload

1814


What do you mean by teradata intelliflex?

1167


What are the various indexes in teradata?

1094


What do you mean by ttu in teradata?

1082


How would you load a very large file in teradata in general? What utility would you use for it? Why?

1142


Explain teradata architecture?

1147


What is smp and mpp platforms?

1034


When tpump is used instead of multiload?

1143


Explain and compare pros and cons of snow flake schemas?

1087


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1075


What are the newly developed features of Teradata?

1081