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

How is MLOAD Teradata Server restarted after execution?

645


What are the updated features of teradata?

576


What is the difference between global temporary tables and volatile temporary tables?

631


How will you solve the problem that occurs during update?

577


Discuss the advantages of using partitioned primary index in a query?

526






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

618


What are the various indexes in teradata?

561


Explain PDE.

602


What does Amp contain and what are all the operations that it performs?

585


What is oltp?

566


How do you verify a complicated sql?

623


What are differences between teradata and ansi session modes in teradata?

617


What is the use of virtual processor connectivity in teradata?

563


What is stored procedure in teradata?

584


Write a program to show the parser component used in teradata?

547