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

Explain some differences between mpp and smp?

1109


What is meant by a Channel Driver?

1251


What are the available primary index types?

1222


What is primary index and secondary index?

1029


What is the purpose of joins in teradata and what are the available join types?

1090


What is the purpose of upsert command?

1180


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2123


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2423


What is real time and near real time data warehousing?

1120


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1049


Highlight a few of the important components of Teradata?

1031


How many sessions of MAX is PE capable of handling at a particular time?

1085


Where is teradata rdbms used?

1104


why use references rather than pointers in the public api, particularly for arguments which are modified?

1011


What do you mean by teradata intelliflex?

1112