why varchar takes 2 extra bytes?
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 |
How is MLOAD Client System restarted after execution?
What are the steps to create a data model?
How many types of joins are there in teradata?
I want to write one query How to get Matched records and unmatched records in table?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
What is teradata? What are some primary characteristics of teradata?
If RDBMS is halted what will you do ?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the functions performed by bynet?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
How do you see a ddl for an existing table?