Interested to Buy Any Domain ? << Click Here >> for more details...
why varchar takes 2 extra bytes?
- 4 Answers
- 15254 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mirza baig
to store the exact no. of characters stored in the varchar
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / 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 |
Answer / 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 |
Answer / kallol
The two bytes are for the number of bytes for the binary
length of the field
| Is This Answer Correct ? | 1 Yes | 1 No |
What do you mean by teradata intellicloud?
Differentiate database data and data warehouse data?
What are the different table types that are supported by teradata?
Explain the types of join supports by teradata?
Describe primary index in teradata. And what are the available primary index types?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
what is single value and Multivalue ?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
what are the file sizes in your project?
Explain teradata architecture?
Explain and compare pros and cons of start schemas?
Why do Hash joins usually perform better than Merge Joins?
Teradata 
