Sybase 12.5 Features



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 








Please visit our other site ...
Rocket99 Guide to Bars, Restaurants, and More!

Technical References Page

email ... js99@rocket99.com

Copyright 1998-2006 © Citisoft, Inc. All Rights Reserved.