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 |
What is the diffrence between Multiload & Fastload interms of Performance?
what is the difference between filter and router transmissions
Can you connect multiload from ab initio?
What is teradata and why it is used?
How do you design aggregate tables using teradata?
What is meant by MATCHTAG in multiload utility?
wt r before journal& after journel.....in teradata
What is the purpose of joins in teradata?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
How many macros we can create inside a macro
What is Difference b/w PI & PPI?how to implement PPI?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance