Maximum Column Sizes

SAP ASE extended-limit capabilities vary by type of table and the database logical page size

The column and row limits for allpages-locked (APL) tables are:

Maximum APL Table Limits

Number of Columns

Column Size 2K Page

Column Size 4K Page

Column Size 8K Page

Column Size 16K Page

Fixed-length column

1024

1960 bytes

4008 bytes

8104 bytes

16296 bytes

Variable-length column

254

1948 bytes

3988 bytes

8068 bytes

16228 bytes

The column and row limits for data-only-locked (DOL) tables are:

Maximum DOL Table Limits

Number of Columns

Column Size 2K Page

Column Size 4K Page

Column Size 8K Page

Column Size 16K Page

Fixed-length column

1024

1958 bytes

4006 bytes

8102 bytes

16294 bytes

Variable-length column

1024

1954 bytes

4002 bytes

8098 bytes

16290 bytes