why varchar takes 2 extra bytes?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the primary characteristics of the Teradata.

593


How to run a query in teradata?

585


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1502


What is teradata? Also, list out some of the primary characteristics of teradata.

580


how many modules are there in telecome domain?how to explain the architecture?

1558






While creating table my dba has fallback or no fallback in his ddl. What is that?

695


What is the multi-insert?

614


What is multi insert?

628


What are default access rights in teradata? What explicit right can be given to a user?

652


Highlight the advantages of PPI(Partition Primary Index).

563


if collect stats but it show low confidence why?

1192


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3001


What do you mean by caching in teradata?

609


how can we analyze the locks ?

1700


How does hashing happens in teradata?

622