Archives of the TeradataForum
Message Posted: Thu, 02 Mar 2006 @ 11:15:01 GMT
Subj: | | Re: SQL for record length calculation |
|
From: | | Victor Sokovin |
| Is this a correct SQL statement to calculate record length? | |
I guess this depends on the purpose of the calculation.
The formula above will give you an idea of the *maximum* number of bytes which may be allocated for the data in a row. If, for example, you
have VARCHAR(N) columns then all of them must be filled up to their respective Ns to attain that maximum. If you use multibyte encodings you
should be aware of the difference between the number of characters and the number of bytes allocated.
All of this is only data related; the formula does not take into account the space Teradata might need to allocate for internal technical
purposes.
Regards,
Victor
|