Interested to Buy Any Domain ? << Click Here >> for more details...
why varchar takes 2 extra bytes?
- 4 Answers
- 15425 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 |
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
What do you mean by teradata intellicloud?
What are the string manipulation operators and functions associated with teradata?
What is the command in bteq to check for session settings ?
How to Extract data from multiple legacy systems?
What is the difference between fastload and multiload?
Syntax for case when statement?
What is Join Index in TD and How it works?
What is real time and near real time data warehousing?
What is difference between user and database in teradata?
What's the difference between timestamp (0) and timestamp (6)?
Teradata 
