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 are the functions involved in shared information architecture?

600


What is real time and near real time data warehousing?

672


What is multi insert?

624


What is the multi-insert?

609


Highlight the limitations of TPUMP Utility.

602






What is basic teradata query language?

632


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

620


Describe the between keyword in teradata?

612


Difference between multiload and tpump?

617


Describe the set operators in teradata.

581


How do you determine the number of sessions?

610


What are the various indexes in teradata? Why are they preferred?

556


What is a dimension table?

608


Highlight the differences between Primary Key and Primary Index.

616


any one answer me how they can analyzing the project using data ware housing?

2025