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?

Answers were Sorted based on User's Feedback



why varchar takes 2 extra bytes?..

Answer / mirza baig

to store the exact no. of characters stored in the varchar

Is This Answer Correct ?    7 Yes 2 No

why varchar takes 2 extra bytes?..

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

why varchar takes 2 extra bytes?..

Answer / quesanswer

Each VARCHAR has two extra bytes reserved for it. One bite
for the preceding NULL indicator and one trailing byte
because VARCHAR is implemented as a ZSTRING.

Is This Answer Correct ?    2 Yes 0 No

why varchar takes 2 extra bytes?..

Answer / kallol

The two bytes are for the number of bytes for the binary
length of the field

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Teradata Interview Questions

What is teradata and why it is used?

0 Answers  


Differentiate primary key and partition key?

0 Answers  


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

0 Answers  


Hash collision?

3 Answers   Satyam,


what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  


What is the purpose of using case expression in teradata?

0 Answers  


What is spool space? Why do you get spool space errors?

0 Answers  


Explain the parallel data extension in teradata?

0 Answers  


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,


How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,


Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,


I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,


Categories