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

what is sysdba and sysdbc ? which has high priority ?

3372


Give a justifiable reason why Multi-load supports NUSI instead of USI.

678


What is meant by Teradata Gateway?

584


What is the maximum number of dml can be coded in a multiload script?

621


Explain the term 'foreign key' related to relational database management system?

558






What are the functions of a teradata dba?

600


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

597


What are the different table types that are supported by teradata?

539


What are the available primary index types in teradata.

589


How can you track login parameters of users in teradata?

634


What is the difference between fastload and multiload?

800


Highlight the need for Performance Tuning.

592


Explain Teradata performance tuning and optimization?

703


Give the sizes of SMALLINT, BYTEINT and INTEGER.

668


How to eliminate product joins in a teradata sql query?

605