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 is the primary index in teradata?

588


What is the opening step in basic teradata query script?

595


What is called partitioned primary index (ppi)?

559


What is TPD?

903


What are the joins in teradata?

568






What is the use of stored procedures in teradata?

563


Explain teradata architecture?

632


Explain the term 'tables' related to relational database management system?

593


List out teradata data types?

557


What are the components used in smp and massively parallel processing (mpp) machines?

596


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

1736


What is the use of virtual processor connectivity in teradata?

566


What is real time and near real time data warehousing?

672


Explain the teradata primary index mechanics in detail with a diagram.

566


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

621