Interested to Buy Any Domain ? << Click Here >> for more details...
why varchar takes 2 extra bytes?
- 4 Answers
- 15428 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 object level locking ? where do appear this type of locking ?
What are the newly developed features of Teradata?
What are different table types used in teradata?
What happens when a node suffers a downfall?
Highlight all the modes that are present under Confidence Level.
What do you mean by teradata sql assistant?
in teradata level primary in table level allows duplicates why?
What are default access rights in teradata? What explicit right can be given to a user?
How will you solve the problem that occurs during update?
What is collect State in Teradata ? what it use and how it works??
What are the differences between TerdataV2R5 and V12 Versions please??
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Teradata 
