sybase version
Bum...@gmail.com
SybaseNeal
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....
1> dbcc traceon(3604)
2> go
1> dbcc serverlimits
2> go
..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 DOL 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 DOL 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 DOL 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 DOL table :
1954 4002 8098 16290
Max number of rows per APL data page :
256 256 256 256
Max number of rows per DOL data page :
166 337 678 1361
Sybaseguru
> in what version of sybase does exist the LONG BINARY column?
The Text/Image datatype, which handles binary data up to 2Gb has been around
for 18 years.