|
Category: ASE
Maximum Size of Rows and Columns in an ASE table
| Locking scheme
| Page size
| Maximum row length
| Maximum column length
|
|
2K (2048 bytes) |
1962 |
1960 bytes |
| 4K (4096 bytes) |
4010 |
4008 bytes |
| APL tables |
8K (8192 bytes) |
8106 |
8104 bytes |
| 16K (16384 bytes) |
16298 |
16296 bytes |
| 2K (2048 bytes) |
1964 |
1958 bytes |
| 4K (4096 bytes) |
4012 |
4006 bytes |
| DOL tables |
8K (8192 bytes) |
8108 |
8102 bytes |
| 16K (16384 bytes) |
16300 |
16294 bytes* |
| 16K (16384 bytes) |
16300** |
8191-6-2 = 8183 bytes*** |
* if the table has no columns with variable datatype.
** subject to a max start offset of varlen = 8191.
*** if the table has at least one column with a variable datatype.
Size includes 6 bytes
for the row overhead and 2 bytes for the field length.
|
|
| |
