Version 12.5 has many "wish list" items added - the most notable are the varchar(2000+), more columns per table (1000+), variable page size option (2k-16k), and dynamic reconfiguration enhancements.
Platforms Supported
Compaq Tru64, HP/UX (32 & 64 bit), IBM AIX (32 & 64 bit), Linux, Microsoft Windows NT, Microsoft Windows 98 (clients only), SGI IRIX (32 & 64 bit), Sun Solaris (32 & 64 bit)
High Availability
Hardware/Software Supported Compaq - TruCluster, IBM - HACMP, Sun - Sun Cluster, HP - ServiceGuard, Windows NT - Microsoft Cluster Software (MSCS), Veritas Cluster Software, SGI FailSafe
1.3.1 Database Statistics
(Max) Databases per Adaptive Server Enterprise.. 32,767
Server Size.............................. 8 terabytes
Database size............................ 4 terabytes
Page Size................................ 2K, 4K, 8K, 16K
Databases spanned by one update.......... 16
Databases opened by one transaction...... 16
Tables in a query........................ 50
Logins per server........................ 2,147,516,416
Users per database....................... 2,146,484,223
Groups per database...................... 1,032,193
Columns per table........................ 1024
Arguments to stored procedure............ 2048
1.3.2 Locking
Row Level Locking, Page Level Locking, Data Page Locking,
Table Level Locking, All Page Locking
1.3.3.1 Binary Large Objects (BLOB) (Maximum)
Text..................................... 2 GB
GB Binary....................... up to 16384 bytes
Image.................... 2
Varbinary(n)................. up to 16384 bytes
1.3.3.2 Character (Maximum)
Char(n)........................ up to 16384 bytes
Varchar(n)..................... up to 16384 bytes
1.3.3.3 Numeric (Maximum)
Int............................ +/-2,147,483,647 integer range
Smallint....................... +/-32,767 integer range
Tinyint........................ between 0 and 255 inclusive
Float.......................... 8 byte floating point number
Shortfloat..................... 4 byte floating point number
Decimal, numeric............... 38 digits
Double precision............... 8 byte floating point number
Money.......................... between +/-922,337,203,685,447.5807