Interested to Buy Any Domain ? << Click Here >> for more details...
why varchar takes 2 extra bytes?
- 4 Answers
- 15586 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 are the various indexes in teradata? How to use them?
Can we collect statistics on multiple columns?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What are the functions of a Parser?
What is logical data model?
how can i answer for question like teradat architecture in interveiw
What is a common data source for the central enterprise data warehouse?
What is the purpose of using case expression in teradata?
What are the uses of bynets in multi-node systems?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Write a program to show the parser component used in teradata?
What is the purpose of joins in teradata?
Teradata 
