sybase version

Hello,

Columns greater than 255 characters were introduced in ASE 12.5.
You can type the following command (in recent versions of ASE) to see
what
your server's limits are

1dbcc traceon(3604)
2go
1dbcc serverlimits
2go
etc
Limits as a function of the page size:


Item dependent on page size :
2048 4096 8192 16384


Server-wide, Database-specific limits and sizes

Min number of virtual pages in master device :
11780 22532 45060 90116
Default number of virtual pages in master device :
23556 45060 90116 180228
Min number of logical pages in master device :
11776 11264 11264 11264
Min number of logical pages in tempdb :
2048 1536 1536 1536

Table-specific row-size limits

Max possible size of a log-record row on APL log page :
2014 4062 8158 16350

Physical Max size of an APL data row, incl row-overheads :
1962 4010 8106 16298
Physical Max size of a DL data row, incl row-overheads :
1964 4012 8108 16300

Max user-visible size of an APL data row :
1960 4008 8104 16296
Max user-visible size of a DL data row :
1958 4006 8102 16294
Max user-visible size of a fixed-length column in an APL table :
1960 4008 8104 16296
Max user-visible size of a fixed-length column in a DL table :
1958 4006 8102 16294
Max user-visible size of a variable-length column in an APL table :
1948 3988 8068 16228
Max user-visible size of a variable-length column in a DL table :
1954 4002 8098 16290

Max number of rows per APL data page :
256 256 256 256
Max number of rows per DL data page :
166 337 678 1361