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

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

why varchar takes 2 extra bytes?

Question Posted / chary

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

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

What are the various indexes in teradata? How to use them?

0 Answers  

What happens in a conflict? How do you handle that?

0 Answers  

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

What is stored procedure in teradata?

0 Answers  

where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,

Can you load multiple data files for same target table using fastload?

1 Answers  

What are the design features involved in teradata?

0 Answers  

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,

What are the string manipulation operators and functions associated with teradata?

0 Answers  

Explain PDE.

0 Answers  

What are the different table types supported by teradata?

0 Answers  

For more Teradata Interview Questions Click Here
Categories