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

Differentiate primary key and partition key?

934


What are the uses of client software involved in teradata?

927


Differentiate database data and data warehouse data?

1053


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

928


List out some of the primary characteristics of teradata.

925


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

926


Why is the case expression used in teradata?

1023


What is meant by a Virtual Disk?

1044


What is partitioned primary index (ppi)?

998


How can you track login parameters of users in teradata?

1124


How do you verify a complicated sql?

1012


What do you mean by teradata intellicloud?

977


What are the various indexes in teradata? Why are they preferred?

956


How many codd's rules are satisfied by teradata database?

1044


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2131