Interested to Buy Any Domain ? << Click Here >> for more details...
why varchar takes 2 extra bytes?
- 4 Answers
- 15578 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 is dimensional modeling?
Define views in teradata with syntax.
What happens in a conflict? How do you handle that?
What is meant by a Highest Cost Plan?
Difference between multiload and tpump?
Can we collect statistics on table level?
any one answer me how they can analyzing the project using data ware housing?
Increasing no of amps will increase performance. Is this true?
What are two examples of an OLTP environment?
What's the difference between timestamp (0) and timestamp (6)?
How many types of joins are there in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Teradata 
