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 to load or extract the error table data ?
How to copy teradata scripts from ur remote desktop to server machine?
What is the syntax for case when statement?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
0 Answers Infosys, Wells Fargo,
what is referential constraints?how do you implement RI in teradata?
which option is used to restart the fastexport script ?
What do high confidence, low confidence and no confidence mean in explain plan?
Explain PDE.
What is the difference between teradata and basic rdbms?
What is the difference between SI and JI?
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load